Weird MySQL error

cmiller · April 2nd, 2004, 03:41 PM

Ok, what am I doing wrong here:

Code:

SELECT * FROM ocs_tracker WHERE date > '1080892800' AND date < '1080979199' AND user in (cmiller,dharrington,jmockabee) ORDER BY idnum ASC

results in this error:

Code:

1054 - Unknown column 'cmiller' in 'where clause'

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

Daniel Walker · April 3rd, 2004, 11:41 AM

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.

cmiller · April 5th, 2004, 05:15 PM

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

Daniel Walker · April 6th, 2004, 04:08 AM

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.