将mysql结果放在一个php数组中，像这样？

Question

To get an array like this array("123","456","789"); I use the code:

$Regids = mysql_query("SELECT regid FROM $tabel WHERE active = '1'");
while($row = mysql_fetch_array($Regids))
{
    $result_array[] = "\"".$row['regid']."\"";
}
$regIDs = implode(',', $result_array);
$registrationIDs = array($regIDs); // array("123","456","789");

but I would expect PHP/mySQL has a simpler/faster solution for this?

Answer 1

try this .. use Group concat in query ...

$Regids = mysql_fetch_array(mysql_query("SELECT GROUP_CONCAT(regid) as regids FROM $tabel WHERE active = '1'"));
echo $Regids[0]['regids']; // 123,456,789

for getting result "123","456","789" try this

$Regids = mysql_fetch_array(mysql_query("SELECT GROUP_CONCAT('\"',CONCAT(regid),'\"') as regids FROM $tabel WHERE active = '1'"));
    echo $Regids[0]['regids']; // "123","456","789"