Select from database where username = any value within an array

Question

I have an array called $friends and it has some values

$friends = array(); $friends[0] = 'Alex'; $friends[1] = 'Jake';

I want to be-able for my SQL query to select every array value in this case it is Alex and Jake

$q = "SELECT * FROM posts WHERE username='$friends' ORDER BY id DESC";

But I can't do that, I get a message saying "Notice: Array to string conversion in".

Please help I am quite new to PHP

See http://stackoverflow.com/a/920523/711206 or http://stackoverflow.com/a/23641033/711206 — Federkun, Sep 27 '15 at 16:53

Julio Soares · Accepted Answer · 2015-09-27T16:57:03.657

2

Use implode make the array into a string with the values and use IN for lists in MySQL.

$friends = array('Alex','Jake');
$str     = implode ("', '", $friends);
$q       = "SELECT * FROM posts WHERE username IN ('". $str . "') ORDER BY id DESC";

edited Sep 27 '15 at 16:57

answered Sep 27 '15 at 16:55

Julio Soares

1,200
8
11

Select from database where username = any value within an array

1 Answers1