Alternating Table Colours

I am producing a league table, that is ordered by points, I wish to smarten the table up by alternating the row colours, i am a newbie - and have looked everywhere for an easy solution, can anyone help me please >

Also if my league had 10 age groups, would it be easier to have 10 pages with the php calling each table out, or is there some other ingenious way of knowing what the person wants to see.

This looks like a standard HTML solution

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
<TABLE>
<TR>
<TD BGCOLOR="#0000FF">Hello There</TD>
</TR>
</TABLE>
[/code]
gives you a perfect table column with a Blue background

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by iwarner:
I am producing a league table, that is ordered by points, I wish to smarten the table up by alternating the row colours, i am a newbie - and have looked everywhere for an easy solution, can anyone help me please >
[/quote]

You can adapt the following code to create a table with alternating row colours:

<table>
<?
$row = 0;
$search = mysql_query("select some_columns from some_tables");
while ($search_values = mysql_fetch_array($search)) {
$row++;
if (floor($row/2) == ($row/2)) {
echo '<tr bgcolor="#ffffff">' . "n"; // in white
} else {
echo '<tr bgcolor="#f4f7fd">' . "n"; // in light blue
}
echo ' <td>$search_values["column1"]</td>
echo '</tr>' . "n";
}
?>
</table>

Also if my league had 10 age groups, would it be easier to have 10 pages with the php calling each table out, or is there some other ingenious way of knowing what the person wants to see.

if you have 10 pages then that is 10x the upkeep. I think i can speak for a lot of programmers when i say that i am lazy as hell. I would do it like this:
http://mydomain.com/teams.php3?team=bears

then in your php query the database for $team and display their results.

Another solution to do alternating colors would be to check if $rownumber % 2 != 1, write one HTML color string, else write another.

Cheers guys - help is appreciated, I will crack on with that tonight.