I'm trying to create a tag cloud for my site. Now I have problem to sort the result in the array format as below:
tags=array('weddings' => 32, 'birthdays' => 41, 'landscapes' => 62, 'ham' => 51, 'chicken' => 23, 'food' => 91, 'turkey' => 47, 'windows' => 82, 'apple' => 27, 'apple2' => 37);
What should I do after selecting the data in the query?
$get_tags= mysql_query("SELECT keywords, COUNT(id) from mytable where keywords!='' group by keywords")