Re: Array to string conversion error help needed

THANKS MUCH - Stuart, Tom, unassailable007, David, and Lester !!!!!!!!!! WOW - so helpful Thanks again !!!!!!!! > On Mar 8, 2016, at 10:56 AM, dealtek@gmail.com wrote: > > 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] > -- Thanks, Dave - DealTek dealtek@gmail.com [db-16]