[SOLVED] Query Error

[steveangelis]

I am doing a simple query from a database, nothing fancy, select * from table, except the field I am pulling data from has multiple items in it like this:

 

3,5,7,9,10 etc.  Each of these are in one field in the database.

 

How I make the query select each and every one of those, or just one instead of them all for that matter?

[smerny]

you could use the explode function to get them separated into different elements of an array

 

http://us2.php.net/explode

[wildteen88]

Use the MySQL IN() function in your WHERE clause. Example

 

$ids = '3,5,7,9,10';

$query = "SELECT * FROM table WHERE id IN($ids)";
$result = mysql_query($query);

[steveangelis]

Thank you.