I don't know what the manual says, but if I were you I'd check this:


mysql_select_db($db,$link) or die ("Can't log in at this time");



----- Original Message -----
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 9:51 PM
Subject: Re: [PHP] mysql


> On Thursday 31 January 2002 13:48, Mason Batley wrote:
> > G'day
> >
> > I keep getting an error message of :Warning: Supplied argument is not a
> > valid MySQL result resource in
/var/www/html/RageProject/StripPlayList.php
> > on line 100 Rows:
> >
> >
> > $link = mysql_connect("127.0.0.1", "rage", "rage");
> > mysql_select_db("rage");
> > $query = "Select id from songs
> >                where songname = '$Song' and
> >                artist = '$Artist'";
> > $result = mysql_query($query);
> > $rows = mysql_num_rows($result);         <<< Line 100
> > echo "Rows: $rows";
> > mysql_close($link);
> >
> > Can someone explain why.. I've been trying to work it out for 2 long.
>
> echo $query;
>
>
> to see whether the query looks ok.
>
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
>
> /*
> * UNIX is a Trademark of Bell Laboratories.
> */
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to