Row number

[hyabusa]

Hey, im trying to create a table that shows information from a database... I also want the odd numbered rows to be one color and the rest to be another color. Does anyone know how i could do this?. Ive included the part of the code im trying to do this with.

<?
$Link = mysql_connect ($Host, $DBUser, $DBPass);
$Query = "SELECT * from Courses WHERE software $SoftSign '%$Software%' AND location $LocSign '%$Location%' AND descrip LIKE '%$Keywords%' ORDER by $Sort LIMIT $limit,10";
$Result = mysql_db_query ($DBName, $Query, $Link);
while ($info = mysql_fetch_array($Result)) {
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#CCCCCC">
<? print("$info[title]"); ?>
</td>
</tr>
</table>
<?
}
?>

[stralle]

You would want to loop through the output as you have done and have a counter which adds up for every row. If the counter is even, output a certain colour, else output another colour. For instance this:

if ($counter++ % 2)
echo "<td bgcolor=\"#colour_for_even_rows\">";
else
echo "<td bgcolor=\"#color_for_odd_rows\">";

[Anon]

Even better? At least I like this better.
Specially if your HTML is kinda complex.
And if you need to update your output, there's only one place to change.

<?
if ($counter++ % 2){
$bgTDColor = "#CCCCCC";
}
else {
$bgTDColor = "#FFFFFF";
}

echo "<td bgcolor=\"".
$bgTDColor .
"\">.....</TD>";
?>

echo "<td bgcolor=\"#colour_for_even_rows\">";
else
echo "<td bgcolor=\"#color_for_odd_rows\">";

[hyabusa]

Thanks for your help, but

I know that

$query_result_handle = mysql_query ($Query);
$rows = mysql_num_rows ($query_result_handle);

would count how many rows there are in the query but how do you get it to return what number a certain row is?

Thanks

[tomhath]

How about toggling a flag and setting the color all in one short statement?

$isOdd = true;

while ...
$bgTDColor = ($isOdd = !$isOdd ) ? "#CCCCCC" : "#FFFFFF";

[[deleted]]

Simple: you don't.

Rows do not have numbers.

If you want to print a row number anyway, then the simplest solution is to just add a counter and print that instead.