[PHP] Put output of mysql into an Array

[Frank Keessen]

Hi,

Can somebody help me with the following?

I want to have the outcome of this:

$query = "SELECT markhow, COUNT(*) FROM prospects GROUP  BY markhow";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

Put into an array like this (for example);

array(
                  "January 12" => 52,
                  "August 4" => 45
               );

Thanks for your help!

Regards,

Frank