mysql query

[Anon]

Hi,

I need to get data from a table for 5 up to 40 or 50 rows.

What is the best way to get this data:

1. go through the array with all selected id's and execute a query for each id individually.

or

2. put all id's in a WHERE statement like '.....WHERE id=$id[0] OR id=$id[1] OR id=$id[2] OR etc...'

Can mysql handle such a long query and is it a proper way to do this?

Thanks,
Raoul

[Anon]

You'll want to use : the IN keyword.

select field from my_tab where 'id' in (val1, val2, val3).

http://www.mysql.com/doc/C/o/Comparison_Operators.html

It will considerably faster than re-issuing multiple select starements (well if hundreths of seconds are your thing).

Cheers
Justin

[Anon]

thank you Justin,

will try that!