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)) { while

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

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
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 hoping