I would say SELECT * FROM table ... then loop through with PHP. WHERE is always optional, but usually needed/recommended. Regards, Matthew Moldvan System Administrator Trilogy International, Inc. -----Original Message----- From: shaun [mailto:shaun@mania.plus.com] Sent: Wednesday, April 09, 2003 4:12 PM To: php-db@lists.php.net Subject: SELECT Statement Hi, what is the best way to select rows with an unknown number rowIDs? e.g. SELECT * FROM TABLE WHERE Table_ID = '1', '2', '3' Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php