[snip] On Tue, Jun 10, 2008 at 10:18 AM, Jay Blanchard <jblanchard@xxxxxxxxxx> wrote: > > http://www.php.net/mysql_num_rows That would be just peachy if it worked on his Informix database, Jay. ;-P [/snip] OK, OK...so I read it through too quickly! Then I would suggest a second query to count the rows. ifx_affected_rows cannot be relied on for accurate counts in SELECT queries, it is on accurate for INSERT, UPDATE, and DELETE statements. ifx_num_rows may be soon to be an included function. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php