On Wed, 21 Mar 2001, boclair wrote:
> 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
>
> Tim Morris
>
>
>
you need to pass the quotes to mysql, hence you have to backslash them in
the php code. Try :
$query="SELECT * FROM members WHERE status = \"deceased\"";
--
Ben
History is curious stuff You'd think by now we had enough Yet the fact
remains I fear They make more of it every year.
--
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]