Mulitple query results!

[intermediate]

how do i ask for multiple results in a mysql query.

ex: $query = "select * from $table where id='1'";

there i asked in the query for it to retrieve all of the rows in the database where the id is 1. how would i ask it to give back multiple things like in one query statement ask it to give me back all rows where id='1' and id='3' and id='6' just as an example.

plz help =(

[cahva]

$query="SELECT * FROM $table where id='1' OR id='3' OR id='6'"

So use or, not and...

[amcgrath]

$query = select * from table where id in (1,2,3,4) is a lil cleaner.

amc