Tim,
Your missing a double quotation prior to your SELECT.
Further, are you connected to a database? :
$result=mysql_query($sql,$db);
Chris
> -----Original Message-----
> From: boclair [mailto:[EMAIL PROTECTED]]
> Sent: 20 March 2001 14:54
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Select where
>
>
>
> ----- Original Message -----
> From: boclair <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 21, 2001 12:02 AM
> Subject: [PHP-DB] Select where
>
>
> > This is simple but I cannot see where I am going wrong
> >
> > I have a table members with one of the fields
> > status, varchar(10)
> >
> > The values may be active or retired or deceased or null
> >
> > If I run the select
> >
> > SELECT * FROM members WHERE status = 'deceased';
> >
> > I get MySQL said: You have an error in your SQL syntax near
> > '\'deceased\';' at line 1
> >
> > Will somebody show me the correct syntax
>
> _______________________
>
> > $query = "SELECT * FROM members where status='deceased'"
> >
> > Then just call the $query in your script
> _______________________________
>
> Thanks, I only gave the mySQL but the php scripting is
>
>
> $deceased = mysql_query(SELECT * FROM members where
> status=\'deceased\'");
> and later
> while ($myrow = mysql_fetch_row($deceased))
>
> MySQL now says in relation to the *while* line
> Warning: Supplied argument is not a valid MySQL result resource
>
> Tim Morris
>
>
>
> --
> PHP Database 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 Database 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]
