Table colours fail when extra row added
Posted: Wed Oct 21, 2009 10:46 am
Hey Gurus,
I got a weird problem with formating the colour of a table made in php. Everything works fine when i use 5 rows each row has an alturnative colour, but when i add the 6th row the colour fails and every row is the same colour which is the first colour (green). I used the same technique on every row so i dont understand how it fails with an extra row. Heres the code:
that last row
How can i fix this?
I got a weird problem with formating the colour of a table made in php. Everything works fine when i use 5 rows each row has an alturnative colour, but when i add the 6th row the colour fails and every row is the same colour which is the first colour (green). I used the same technique on every row so i dont understand how it fails with an extra row. Heres the code:
Code: Select all
$result = mysql_query("SELECT * FROM fulldata WHERE approved = '0'") or die(mysql_error() );
$i=1;
$row = mysql_fetch_array($result);
$line = mysql_fetch_assoc($result);
// headers of the table
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>";
echo "<tr><td align='left' width='40%'><b>Description</b></th><td align='center' width='30%'><b>Proof</b></th><td align='center' width='10%'><b>Workers Needed</b></th><td align='center' width='10%'><b>Price</b></th><td align='center' width='10%'><b>Accept</b></th><td align='center' width='10%'><b>Deney</b></th></tr>";
// ITERATE OVER THE RESULTS SET
while ($line = mysql_fetch_assoc($result))
{
// GET EASY-TO-READ LOCAL VARIABLES
foreach ($line as $key => $val) { $$key = htmlentities($val); }
// CREATE THE ROW OF DATA
$color = ($i % 2) ? "#3F6" : "#3CF";
echo "<tr>";
echo "<td style='background-color:$color' align='center'>$descript</td>\n";
$i++;
echo "<td style='background-color:$color' align='center'>$proof</td>\n";
$i++;
echo "<td style='background-color:$color' align='center'>$amountworkers</td>\n";
$i++;
echo "<td style='background-color:$color' align='center'>$perperson</td>\n";
$i++;
echo "<td style='background-color:$color' align='center'>Accept</td>\n";
$i++;
echo "<td style='background-color:$color' align='center'>Deney</td>\n";
$i++;
}
// END WHILE ITERATOR
echo "</table>\n";
// END IF/ELSE
?>
when added ruins all the colours. when taken out the table works fine.echo "<td style='background-color:$color' align='center'>Deney</td>\n";
$i++;
How can i fix this?