Not sure here, but you might also run into a problem if you start your if statement with $i=0. If PHP does not treat the value 0 as even or odd, your first row is most likely going to be purple along with your second row. I know it's nitpicky, but I could see myself spending half an hour trying to figure out why the code works, but not the way I want it to.
> -----Original Message----- > From: Brad Bonkoski [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 26, 2002 11:10 AM > To: Patrick Lebon; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Current row of query > > > oops... > > I meant: > (if $i is odd) > ... > > because $i would be the current index in the array. > > > Brad Bonkoski wrote: > > > why not this? > > > > $result = mysql_query("Select * from table'); > > $num_rows = mysql_num_rows($rows); > > > > for ($i=0; $i<$num_rows, $i++) > > { > > $row = mysql_fetch_array($result); > > if ($num_rows is odd) > > { > > print $row with BG color of red; > > } > > else > > { > > printf $row with BG color of purple; > > } > > } > > > > HTH > > -Brad > > > > Patrick Lebon wrote: > > > > > Is there a mysql or array variable for the current row of > a query array? > > > I want to alternate background colours for each row of > the query output so i > > > need to know the current row number. > > > > > > Thanks > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php