On Mon, 29 Nov 2004 17:27:26 +0200, Phpu <[EMAIL PROTECTED]> wrote:
> I have an array named $ex_array.
>
> I want to search the database and find those ids that are different from the
> values in $ex_array.
>
> I use this but didn't work
>
> $sql = "SELECT product_id FROM products WHERE product_id <> '$ex_array' " ;
$sql = "
SELECT
product_id
FROM
products
WHERE
product_id NOT IN ( "
. implode( ', ', $ex_array )
. " ) ";
This question would be more appropriate for the php-db list.
--
Greg Donald
Zend Certified Engineer
http://gdconsultants.com/
http://destiney.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
