Put some table results in an array

[wee493]

I'm wanting to get table results from a database and put them in an array. I've tried using the below code which is a very poor way of doing this and it doesn't work correctly. Any ideas?

 

$sql = mysql_query("SELECT feed_url FROM sc_feeds");
$feed = 'array(';
while ($r = mysql_fetch_array($sql)){
$feed .= '"'.$r['feed_url'].'", ';
}
$feed .= ')';

echo $feed;

[PFMaBiSmAd]

That's only building a string that has the syntax of a php array statement.

 

$sql = mysql_query("SELECT feed_url FROM sc_feeds");
$feed = array(); // define an empty array
while ($r = mysql_fetch_array($sql)){
   $feed[] = $r['feed_url']; // add an element to the array
}

echo '<pre>',print_r($feed,true),'</pre>';