Array to string conversion error help needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx
[db-16]


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux