Re: [PHP] using mysql_query() twice?

2002-01-11 Thread Erik Price
On Friday, January 11, 2002, at 05:42 PM, Nick Wilson wrote: > That's not it. Your first $result is a resource indicator (container for > results) so if you re-assign it (put another value into it) it becomes > useless as your while statement depends on it. (This may be redundant, but I'm hopi

Re: [PHP] using mysql_query() twice?

2002-01-11 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * On 11-01-02 at 23:39 * Erik Price said > > EXCELLENT! > It worked perfect. > So $result can't be used twice -- I wonder if it somehow is altered by > the mysql_fetch_array() that is performed upon it. That's not it. Your first $result is a

Re: [PHP] using mysql_query() twice?

2002-01-11 Thread Erik Price
EXCELLENT! It worked perfect. So $result can't be used twice -- I wonder if it somehow is altered by the mysql_fetch_array() that is performed upon it. Thanks Nick. On Friday, January 11, 2002, at 05:23 PM, Nick Wilson wrote: > I'll most likely be corrected (I just joined the list to brush u

Re: [PHP] using mysql_query() twice?

2002-01-11 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- 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)) { >

[PHP] using mysql_query() twice?

2002-01-11 Thread Erik Price
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 dat