Strange MySQL error!

[djumaka]

Hello to all the gurus out there!
Today Icame across to a very strange error:
"1064:You have an error in your SQL syntax near '' at line 1", but the sql statement is an ordinary one - "select id,name,dep,pos,email from users where id=$i".

I used both mysql_db_query() func. and and the long analog - mysql_select_db(); mysql_query().The database server is MySQL 1.2.23.

Please help me, I feel extremely helpless!
Thaks in advance!

Djumaka.

[[deleted]]

Most likely: $id is empty, and your query is executed as:
"select id,name,dep,pos,email from users where id="

which will give an error stating that you have an 'end-of-string' where SQL expects to get a value for the id field.

[Anon]

now that is a strange error. (sarcasm) it could be anything. columns might not exist, the table might not exist..whatever..also try putting that var($i) into single quotes.

[[deleted]]

"it could be anything"

Actually it means exactly one thing; that some data was left out of the query.