RE: Using a loop on a result destroys array??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 
On Wednesday, November 24, 2004, at 02:40PM, Norland, Martin <Martin.Norland@xxxxxxxxxx> wrote:

>The real problem you're having is the statement says "while there are
>results in this query, grab them" - once you reach the end of the first
>while loop, there are no more results, so the second one is skipped
>right over - it's condition *never* evaluates true.

So by running a "while (mysql_fetch_array($result)" loop over a fetch array you effectively empty it?

>If the query isn't changing, and there aren't other conditions/etc. -
>then just grab all the data the first time through and put it where it
>needs to go.

OK, sounds like a plan...

Sorry (again) about the code gaffs :-S

-- 
Mark Benson

http://homepage.mac.com/markbenson

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux