RE: [PHP] Select IN array?
| From: | Chris Lott | Date: | Sat, 14 Jul 2001 20:57:46 +0000 |
| Subject: | RE: [PHP] Select IN array? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57904@lists.php.net to get a copy of this message | ||
> I have an array of id numbers ($catids).
> This syntax fails:
> select * from categories
> where cid in $catids
Never mind. I was being stupid. For the record, one needs to implode(",",
$catids) and then use that in the WHERE statement, i.e. "where cid in
($catids)"
c