Ok, what am I doing wrong here:

results in this error:

Am I missing something, because I have this running just fine in another script (on a different machine).

Thanks in advance for the help.


----------
~cmiller

__________________
----------
~cmiller

Single quotes around your values in the list, maybe?

Either that, or your machine may be using some ancient version of mysqld that doesn't support IN.

Ok, that works... So putting single quotes around the items in the IN clause gets a result, however that variable is being generated from an implode from an array, so I don't have a lot of control over the output. Any other suggestions?

Here's what I'm trying to accomplish:
I am running a report on employee time. You select the employees that you want to include in the report by checking checkboxes next to their names. <input type=text name="empid[]" value="cmiller">, then from within the PHP you: $emp_list = implode(",", $empid); and then run the query... SELECT * FROM blah WHERE user IN ('$empid');

Anyone got an suggestions?

----------
~cmiller

Just off the top of my head....

 $emp_list = implode("','", $empid);
$emp_list = "'" . $emp_list . "'";

It's an ugly kludge, but I think it'll work.

Unless you quote the values, MySQL thinks it's being passed a column names, as your first error indicated.