Create Comma Seperated List from MySQL PHP

Question

I have a list of users in my table. How would I go about taking that list and returning it as one PHP variable with each user name separated by a comma?

Answer 1

You could generate a comma-separated list with a query:

SELECT GROUP_CONCAT(username) FROM MyTable

Or else you could fetch rows and join them in PHP:

$sql = "SELECT username FROM MyTable";
$stmt = $pdo->query($sql);
$users = array();
while ($username = $stmt->fetchColumn()) {
    $users[] = $username;
}
$userlist = join(",", $users);

Answer 2

You would fetch the list from the database, store it in an array, then implode it.