on 1/16/02 11:57 AM, Mike Krisher at [EMAIL PROTECTED] wrote:

> someone here has to know the syntax for using multiple items in a where
> definition, something like:
> $values = 120106,120095;
> $sql = "SELECT * FROM products WHERE catalognumber = $values ORDER BY
> price";

select * from products where catalognumber in (120106,120095) order by

you may need quotes around the stuff in the parens, ('120106','120095')

 -- mike cullerton   michaelc at cullerton dot com

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to