Re: [PHP] Re: Troublesome Code.

[Chris Knipe]

Had a fault in some globally included mysql structures... I don't know how 
this happened, but my mysql_select_db seemed to have dissapeared.  Thus 
there was no database initialised, and hence all the queries actually did 
not complete.

I sorted it out - it's all working now :)  Thanks for the suggestions 
everyone.

--
Chris.
----- Original Message ----- 
From: "Mikey" <[EMAIL PROTECTED]>
To: <php-general@lists.php.net>
Sent: Monday, January 31, 2005 3:15 PM
Subject: RE: [PHP] Re: Troublesome Code.


>    if (mysql_num_rows($SQL) == 1) {
Err, this is just the query string variable right? So you need to do:
$sth = mysql_query ($SQL);
If (mysql_num_rows ($sth) == 1)
Then you will be checking the result set and not just the query string.
HTH,
Mikey
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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