Put output of mysql into an Array
| From: | Frank Keessen | Date: | Sat, 01 Nov 2003 10:04:58 +0000 |
| Subject: | Put output of mysql into an Array | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-168258@lists.php.net to get a copy of this message | ||
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