Echo a PHP array into a format

[gergy008]

Hi everyone, Thanks for lookin at the thread

 

I was wondering if I could have a little help echoing an array of all the users in my DB into a format of for example

 

'cow' , 'pigeon', 'giraffe'

 

$sql='SELECT `login` FROM `users`;';
$run=$mysql_query($sql, $link);

 

I do know that you need to use the while statement but I am not that confident in using it, It's completely blanked out of my head.

 

Thanks in advance!

 

PS. I will be working on it too, Please don't think I'm just shoving you a job under your nose because I can't be bothered to do it >_<

[Alex]

$sql = 'SELECT `login` FROM `users`;';
$run = mysql_query($sql, $link);
$users = array();
while($row = mysql_fetch_assoc($run)) {
    $users[] = $row['username'];
}
echo "'" . implode("', '", $users) . "'";