Posted By

Darksider3 on 07/26/11

Tagged

Versions (?)

Last Edited at 07/26/11 02:21am

Statistics

Viewed 771 times

Favorited by 0 user(s)

Related snippets

Make your table color different by Mysql Select tag

/ Published in: PHP

Here you see a example to make your table background color fdifferent at last

Highlighted TextExpand

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Abwechselnde Zeilenfarben(MYSQL)</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0"
    class="tableLine" height="100%">
<?php
mysql_connect(''localhost'', ''root'', ''****'');
mysql_select_db("ldg-php");
$sql = mysql_query(''SELECT * FROM news'');
while($res=  mysql_fetch_array($sql)){
    if($res[''id''] % 2){
        echo "<tr><td class=''row_0''>Eintrag nr. $res[id]<br />$res[text]</td></tr>";
    }
    else {
        echo "<tr><td class=''row_1''>Eintrag nr. $res[id]<br />$res[text]</td></tr>";
    }
}
echo "</table>";
?>

URL: http://darksider3.pf-control.de/all/scripts.php?id=Abwechselnde%20Tabellenfarben%28MYSQL-SELECT

Report this snippet Tweet