If it were me, I would use the IN clause and make a list of the items to
choose from. Your SQL would look like:
SELECT * FROM table WHERE Table_ID IN ('1','2','3')
hope this helps
Jim
-------Original Message-------
From: shaun
Date: Wednesday, April 09, 2003 13:17:53
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
