Hash: SHA1

* On 11-01-02 at 23:08 
* Erik Price said....

> I am curious if using the same mysql_query() function twice causes some 
> kind of problem.
> It seems that if I use
> $result = mysql_query($sql, $db);
> if (mysql_fetch_array($result)) {
>     while ($row = mysql_fetch_array($result) or die("You lose.  No data 
> fetched.")) {
>          // print some data
>          // print a simple sentence to see if the WHILE statement even 
> executes
>     }
> } else {
>     // print "No results match your criteria"
> }
> IF statement is true but the WHILE statement doesn't seem to produce its 
> intended effect.  In other words, I get the die() message "You lose.  No 
> data fetched."

I'll most likely be corrected (I just joined the list to brush up on my
php) but I think that if you change this 

>     while ($row = mysql_fetch_array($result) or die("You lose.  No data 

to this

>     while ($row = mysql_fetch_array($another_result) or die("You lose.  No data 

You'll be on the right track.

> This leads me to believe that I can't run two instances of mysql_query() 
> or perhaps mysql_fetch_array().

No, of course you can.

- -- 

Nick Wilson

Tel:    +45 3325 0688
Fax:    +45 3325 0677
Web:    www.explodingnet.com

Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org


PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to