That is a really poor solution, what if your table has 35 million rows? You are much better off only pulling what you need. The previous answers that refrence using the IN() operator are the way to go. > -----Original Message----- > From: Matthew Moldvan [mailto:mmoldvan@trilogyintl.com] > Sent: Wednesday, April 09, 2003 1:16 PM > To: 'shaun'; php-db@lists.php.net > Subject: RE: SELECT Statement > > > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
