Row Colors

Nathan__02

I read and followed a tutorial that showed me how to have alternating row colors...but i want it for a database that uses while(). It doesnt show the row colors and i think it is because of while(). heres my code

<?php

include("config.php");
include("style.css");

$query=mysql_query("SELECT * FROM users");

echo("<div style='position:absolute; top:100; left:100; width:800'>");

$colors = array (
0=> "#303030",
1=> "#FFFFFF"
);

$total_colors = count ($colors); 

$pretend_rows=30;

echo("<table width='350'>");

for ($i = 0; $i < $pretend_rows; $i++) {

$remainder = $i % $total_colors;
$bgcolor= $colors[$remainder];

while ($row=mysql_fetch_array($query)) {

$username=$row["username"];
echo("<tr bgcolor='$bgcolor'><td><a href='/shelta/viewmember.php?$username'>$username</a></td><td>$i</td></tr><BR>");
}
}


echo("</table></div>");

?>

jpmoriarty

why do you need the while at all? why not just have

$row = mysql_fetch_array($query);

Your for loop should step through the results for you

leatherback

Hi,

What is the pretend rows for?

I think you should move the whole section

$remainder = $i % $total_colors;
$bgcolor= $colors[$remainder];

into the while statement. Before the while statement you set $i: $i=0

Leave the 'for ($i = 0; $i < $pretend_rows; $i++)
' out. Then rewrite it a bit, to something like:

$remainder = $i % $total_colors;
$bgcolor= $colors[$remainder];
$i++

Hope this helps.

Nathan__02

when i do that it just shows one username. this is the code i used

<?php

include("config.php");
include("style.css");

$query=mysql_query("SELECT * FROM users");
$row=mysql_fetch_array($query);

echo("<div style='position:absolute; top:100; left:100; width:800'>");

$colors = array (
0=> "#303030",
1=> "#FFFFFF"
);

$total_colors = count ($colors); 

$pretend_rows=30;

echo("<table width='350'>");

for ($i = 0; $i < $pretend_rows; $i++) {

$remainder = $i % $total_colors;
$bgcolor= $colors[$remainder];



$username=$row["username"];
echo("<tr bgcolor='$bgcolor'><td><a href='/shelta/viewmember.php?$username'>$username</a></td><td>$i</td></tr><BR>");
}



echo("</table></div>");

?>

heres the url

Nathan__02

the pretend rows was just me being lazy. i didnt want to use mysql_num_rows (because im new at this) and didnt have alot of time...i didnt quite understand the whole $i part.

leatherback

'the whole $i part' is nothing more then what's in the manual. You could just as easy call it $counter or anything else. It is a counter, which keeps track of the number of loops you have made. Qith that counter, you can then perform calculations, and it will give you the color to take.

Then I think the suggestion I gave you, will work. But I must admit: I have not done it myself yet. (Will try later next week, when I need to build a site which needs it..)