Re: Put output of mysql into an Array

From:	Burhan Khalid	Date:	Sat, 01 Nov 2003 10:59:16 +0000
Subject:	Re: Put output of mysql into an Array
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-168259@lists.php.net to get a copy of this message

Frank Keessen wrote:

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
               );

http://www.php.net/mysql-fetch-array http://www.php.net/mysql-fetch-assoc Before asking next time, try reading the manual. :| -- Burhan Khalid phplist[at]meidomus[dot]com http://www.meidomus.com