[SOLVED] Can MYSQL Return an array...

[drbigfresh]

I am doing a select like this:

 

$sql="select  keyword from d_list_keyword where listid=" . $_GET['id'];

$result = $db->Execute($sql) or die($db->ErrorMsg());

 

Is there any built in way to have it return the list of keywords as an array (preferably separated by a comma?) so I don't have to loop through it and build it on my own?

 

mysql_fetch_array seems close to what I want, but I can't seem to get it to work.

 

[Barand]

"SELECT GROUP_CONCAT(keyword SEPARATOR ',') as keywords

FROM d_list_keyword

WHERE listid=" . $_GET['id']

 

[drbigfresh]

perfect. thanks!