php - Input keys with values in array -

php - Input keys with values in array -

i have problems filling in array has generated key value database. database returns 2 rows, first row should key , sec value key.

this code:

$days = array(); if($query=db::query("select dayname(date_earned) dayearned, sum(downloads) daydownloaded perf_earnings date_earned between date_sub(curdate(), interval 7 day) , curdate() grouping dayearned")) { while($row=$q->fetch_assoc()){ $day = $row["dayearned"]; $dowsum = $row["daydownloaded"]; $days[$day] = $dowsum; } }

i'm getting empty array.

what want is:

array( [monday]=>230, [tuesday]=>500, [wednesday]=>340, etc. )

well, always, there stupid error whan dont read carefully. did not come in $query right whan wanted fetch_assoc.

i writed "$q" instead "$query".

thanks anyway.

i sense query not getting resultset. first thing in orignial query grouping needs group date_earned instead of grouping dayearned improve way write above code be

<?php $qry = "select dayname(date_earned) dayearned, sum(downloads) daydownloaded perf_earnings date_earned between date_sub(curdate(), interval 7 day) , curdate() grouping date_earned"; $qid = mysql_query($qry); if($qid->num_rows()){ while($row = mysql_fetch_array($qid)){ $day = $row["dayearned"]; $dowsum = $row["daydownloaded"]; $days[$day] = $dowsum; } } ?>

php mysql arrays