I am fetching for some values from the database, and i need to dynamicaly create a multidimensional array to look like this:
$found_data =
array(
array('2011-11-02' => 'Mobile'),
array('2011-11-02' => 'Mobile'),
array('2011-11-04' => 'Mobile'),
array('2011-11-08' => 'Desktop'),
array('2011-11-08' => 'Mobile'),
array('2011-11-08' => 'Mobile'),
array('2011-11-08' => 'Mobile'),
array('2011-11-15' => 'Mobile'),
array('2011-11-18' => 'Mobile'),
array('2011-11-21' => 'Desktop'),
array('2011-11-23' => 'Mobile'),
array('2011-11-28' => 'Desktop'),
array('2011-11-30' => 'Mobile')
);
I am thinking something in the lines of:
$found_data = array();
while($last_30_days_fetch = mysql_fetch_assoc($last_30_days_result))
{
$hit_date = $last_30_days_fetch['hit_date'];
$hit_device = $last_30_days_fetch['hit_device'];
array_push($found_data, array($clean_date=>$hit_device));
}
However the above code, does not work as intended. Any ideas?
// Thanks