getting query results as an arrya

[Lionel]

Hi, I am trying to get the below query to display as an array like

$getdivs=array('0011','0010');

but

$getdivs=array($distinct['divid']);

returns only one value. Please how can the below query be fixed?

Thank you

PHP Code:

$alldivs = $DB_site->query("SELECT divid FROM cclpinternational_predictions WHERE gameover = '1'");
while ($distinct=$DB_site->fetch_array($alldivs)) {

$getdivs=array($distinct['divid']);
}
foreach ($getdivs as $v) 
{ ...... 


[Code Monkey]

PHP Code:

$getdivs[] = $distinct['divid']; 


[Lionel]

Thanks, I appreciate the help.