RE: [PHP] can someone explain this query to me

2005-12-20 Thread Dan Parry
WHERE id IN (1,2,3) Is the same as saying WHERE id = 1 OR id = 2 OR id = 3 Few more details in this link http://www.w3schools.com/sql/sql_in.asp HTH Dan -Original Message- From: Ross [mailto:[EMAIL PROTECTED] Sent: 20 December 2005 12:07 To: php-general@lists.php.net Subject: [PHP] c

Re: [PHP] can someone explain this query to me

2005-12-20 Thread David Grant
Ross, Ross wrote: > $query = "delete from meetings where id IN (".implode(",", $ids).")"; > > Just the end bit, ids is an array of values (1,2,3,4,5) what does the IN > do?? It's the equivalent of WHERE id = 1 OR id = 2 OR id = 3 OR id = 4 OR id = 5. Cheers, David -- David Grant http://www.g