rows: colours and numbers

Anon

how can i change this script in order for the results to be numbered in rows and for every other row to have a color in it like the message board here does ??????
<?
printf (" <table border=\"1\" width=\"567\">
<tr>
<td width=\"300\"><b>Scholarship/Fund</b> </td>
<td width=\"92\"><b>Value</b></td>
<td width=\"175\"><b>Deadline</b></td>
</tr>\n");
?>
<?
$db = pg_connect("","","","","funds");
$query = "SELECT schol_id, schol_name, value, deadline FROM scholarship ORDER BY schol_name";
$result = pg_exec($db, $query);
if (!$result) {print ("ERROR"); exit;}
$numrows = pg_numrows($result);
$row=0;
do
{
$myrow = pg_fetch_row ($result,$row);
print ("<tr><td width=\"400\" valign=\"top\"><b><a href=\"scholview.php?schol_id=".$myrow[0]."\">$myrow[1]</a></b></td><td width=\"92\" valign=\"top\">$myrow[2]</td ><td width=\"75\" valign=\"top\">$myrow[3]</td ></tr>\n");
$row++;
}
while ($row < $numrows);
print ("</table><br>\n");
pg_close($db);
?>

Anon

$color1 = "ffffff";
$color2 = "000000";
$row_num = 0;

while(yourprintingresults)
{
$color = ($row_num%2) ? $color2 : $color1;
$row_num++;
}

cheers.

Anon

do i have to get rid of anything in my script to use this ?? i have a do - while statement ... do i just put everything from my if portion to the while inside of the while here ? i am like 2 weeeks new into this stuff - never even heard of php before that. yer cool though - helped me out a ocuplettimes today already!

Anon

$color1 = "cccccc";
$color2 = "ffffff";
$row_num=0;
do
{
$color = ($row_num%2) ? $color2 : $color1;

$myrow = pg_fetch_row ($result,$row);
print ("<tr><td bgcolor=".$color." width=\"400\" valign=\"top\"><a href=\"scholview.php?schol_id=".$myrow[0]."\">$myrow[1]</a></td><td bgcolor=".$color." width=\"92\" valign=\"top\">$myrow[2]</td ><td bgcolor=".$color." width=\"75\" valign=\"top\">$myrow[3]</td ></tr>\n");
$row++;
$row_num++;
}

Anon

thanks - you da mAN! wouldnt know anything about multiple searches would ya ?