Array to string conversion error help needed
| From: | dealtek@gmail.com | Date: | Tue, 08 Mar 2016 18:56:11 +0000 |
| Subject: | Array to string conversion error help needed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-325447@lists.php.net to get a copy of this message | ||
newbie mysql select help needed.
this works fine...
$sth = $pdo->prepare("SELECT * FROM table1 where id IN (1,2,3)"
but with an array like...
$mylist = array("1","2","3");
or
$mylist = array(1,2,3);
these fail...
$sth = $pdo->prepare("SELECT * FROM table1 where id IN $mylist"
or
$sth = $pdo->prepare("SELECT * FROM table1 where id IN ($mylist)"
I get error : Array to string conversion...
Q: Can anyone help me fix this?
--
Thanks,
Dave - DealTek
dealtek@gmail.com
[db-16]