Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

Re: [PHP-DB] mysql_fetch_array problem From: bleythbe <email protected>
Date: 07/09/01

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 <email protected>>:

> 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 <email protected>
> For additional commands, e-mail:
> php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>