Re: Re: Troublesome Code.

["Chris Knipe" <savage@xxxxxxxxxxxxx>]

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" <frak@xxxxxxxxxxxxxx>
To: <php-general@xxxxxxxxxxxxx>
Sent: Monday, January 31, 2005 3:15 PM
Subject: RE:  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