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]
