PHP: Show 3 records from MySQL (exampel: ID: 5 22 87)

[edge]

I'm feeling so stupid at the moment, but what's the best way to get MySQL to show lets say 3 records.

Example: I want to show record ID 5, 22 and 87 in on go.

Sure I can do a query loop on each record like this

$query_rsFiles = "SELECT * FROM products WHERE `ID` = '$the_ID'";

or get MySQL to do a query on all records , and when the ID is 5 or 22 or 87 are up to show the data, but this looks like a long and not proper way to do it.

Anyone here who might know the correct way of doing this?

Once again.. Sorry for asking this... I know.. I should know things like this.

[edge]

Nevermind..

Found it I think..

$query_rsFiles = "SELECT * FROM products WHERE `ID` = '5' OR `ID` = '22' OR `ID` = '87'";

Not sure if OR is the best way to do it.

[id10t]

select * from table where id=('5','22','87')

You aren't really playing with PHP at this point, you are playing wtih SQL statements.

[topdog]

actually is it

select * from table where id IN (5,22,87)

as id is most likely a numeric value not a string.

[edge]

The OR that I'm using at the moment is working fine, but for sure I will give IN also a go,
And yes.. The ID is a numeric value.

Thank you both for your answer.