MySQL query returns ERROR 1054 (???)

pete07920 · Feb 13, 2001

This query returns an odd error:

SELECT * FROM table_name WHERE user_id = __

I get: ERROR 1054 Unknown column ___ in WHERE clause. The column the error referances is the value I've entered in user_id.

Any ideas?

Pete

(I just "inherited" this project so I'm just getting up to speed with it.)

Anon · Feb 13, 2001

Are you using single quotes around the value of ___ ? This may be causing it if you are not.