Posted by Chris Knipe on 01/31/05 15:33

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@totalise.co.uk>
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
>
>

[Back to original message]