Posted by Sjoerd on 04/17/06 19:58

rjames.clarke@gmail.com wrote:
> I want to check if any of the items in a PHP array exist in a MySQL
> table.

$query = "SELECT COUNT(*) FROM my_table WHERE serialno IN (".implode(',
', $serials).")";

• Next in forum: Re: seperator instead of a comma for listed items in DB?
• Prev in forum: Re: obtaining email address.
• Thread view: Re: Check if any items in an array (php) is in a table (mysql).

[Reply to this message]