NYCPHP Meetup

[Anirudh Zala]

You seems have problem with your db server or sql execution mechanism. Because all queries except 2nd & 4th are correct and will run successfully on mysql DB. However results may vary from query to query.

Thanks

Anirudh Zala

On Tue, 06 Dec 2005 10:06:15 +0530, Anthony Papillion <papillion at gmail.com> wrote:

> Thanks to everyone who responded to my SQL syntax question. However, for
> some strange reason, I am STILL getting an error. So far, I've modified my
> SQL statement the following ways:
>
> SELECT * FROM sisters WHERE email != 'email address' ORDER BY RAND() LIMIT 1
>
> SELECT * FROM sisters WHERE email NOT 'email address' ORDER BY RAND() LIMIT
> 1
>
> SELECT * FROM sisters WHERE email NOT LIKE 'email address' ORDER BY RAND()
> LIMIT 1
>
> SELECT * FROM sisters WHERE email IS NOT LIKE 'email address' ORDER BY
> RAND() LIMIT 1
>
> SELECT * FROM sisters WHERE email <> 'email address' ORDER BY RAND() LIMIT 1
>
> None, of these statements work and yet they all look (at least to me)
> syntactically correct. Could this be a problem with my db server??
>
> Anthony
>
> --
> Anthony Papillion
> Phone: (918) 926-0139
> ICQ: 96-698-595
>
> CAN ONE VOICE CHANGE THE WORLD?
> http://www.one.org
>



-- 
-----------------------------------------------------
Anirudh Zala (Production Manager)
ASPL, http://www.aspl.in
Ph: +91 281 245 1894
arzala at gmail.com
-----------------------------------------------------