Re: Array to string conversion error help needed
| From: | Stuart Dallas | Date: | Tue, 08 Mar 2016 19:08:09 +0000 |
| Subject: | Re: Array to string conversion error help needed | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-325449@lists.php.net to get a copy of this message | ||
On Tue, 8 Mar 2016 at 18:56 dealtek@gmail.com <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?
>
Look at http://php.net/implode
-Stuart