Re: mysql_fetch_array problem

I was having the same problem for a while... although, I was using this: for($i=0;$i<mysql_num_rows($result);$i++) doStuffTo(mysql_result($result, $i, "foo"); If I remember correctly... it has to do with zero-based indexing versus 1-based indexing. Now... I think I fixed it by using <= instead of just <. But, it has been a while so I could be totally off => Good luck, Ben Quoting BrianSander <yoda@ipo.vpaa.asu.edu>: > Greetings, > > I'm experiencing the strangest problem and I was > wondering if anyone > else has had the same problem. > > I have a fairly simple script setup that queries > a mySQL database and > displays the records in a HTML table. Everything > works fine except it > keeps omitting the first record. Running the > query directly on the > database returns 3 records but only 2 are > displayed in the table. > > I just upgraded to PHP 4.0.6 and I'm still > having the problem. I've also > tried using mysql_fetch_array and > mysql_fetch_object, both produce the > same results. The first record is left out every > time. > > Any idea as to what the problem might be? > > > Thanks. > > -- > PHP Database Mailing List > (http://www.php.net/) > To unsubscribe, e-mail: > php-db-unsubscribe@lists.php.net > For additional commands, e-mail: > php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > >