I have some id numbers stored in a sql database under a field called "idnums", for example, one of my rows stores id numbers in field "idnums" in the following format
each number is a id number in another table.
I insert the id numbers from a multiple selection list on a form using the 'join' function.
I then have a php query which looks like
$query=MYSQL_QUERY("SELECT * FROM order");
I want to be able to select just the id numbers from the table "orders" that are stored in the "idnums" field, I thought I could do
$query=MYSQL_QUERY("SELECT * FROM order WHERE id = $idnums");
but it doesnt seem to be able to do that, how could I get it to do this?
Any help would be ace
Thanks in advance