then add an extra conditional to check if $i is equal to 0, or start $ off as 1so, for ($i=1, $i<$num_rows+1; $i++) -or- if ($i==0) //treat as even
either way woudl work. -Brad "Hutchins, Richard" wrote: > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php