Re: mysql_fetch_object and modulo %

From: Date: Wed, 19 Nov 2008 14:32:00 +0000
Subject: Re: mysql_fetch_object and modulo %
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-283532@lists.php.net to get a copy of this message
Alain Roger wrote:
Hi, how can i do to test if the row number (record number) sent by mysql_fetch_object is odd or even ? i mean that: while ($row = mysql_fetch_object($result))
    {
     if($row%2 == 1)
     {
      ...
     }
    }
the $row doesn't return a value... like 1, 2 or 6 for example... thx. F That's because $row is an object. Return your row uid (unique identifier; primary key w/ auto increment) and do:
while ( $row = mysql_fetch_object($result) ) {
    if( $row->UID % 2 == 1 )
    {
     ...
    }
} replacing UID with whatever you called the field in the database. Hope this helps, - Craige

« previous php.general (#283532) next »