SQL syntax error

[mishasoni]

PHP newbie here.

 

I am getting a SQL syntax error on the following code:

 

$query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 ORDER BY NameLast ASC";

 

The exact error message is: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY NameLast ASC LIMIT 0, 30' at line 1"

 

For the life of me I can't figure out what is wrong as it was working previously.  Any thoughts?

[kenrbnsn]

The "not equal" operator is "!=", not "<>".

 

Ken

[revraz]

And that looks like the wrong line, I dont see a LIMIT 0, 30 on that query.

[mishasoni]

Changing the operator didn't work.  Now the error just says: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY NameLast ASC' at line 1".

 

The only line of code containing this text on the page is the one I previously provided.

[revraz]

Put single quotes around the 0

 

AND ContactID_pk <> '0'

 

And there had to be another line, unless you removed the LIMIT.

[mishasoni]

Also, running a recordset test in Dreamweaver works fine with no errors.