[flexcoders] Populating column chart with PHP MySQL

[ghus32]

Hello,

I have done this with many datagrids and had success but cant seem
to get it to work with the column charts.

I have several different queries in php where I get the data from but
I dont know the format. an example of the php code below

I would like to have $num_signage and $num_website as datagrid 
columns, plus I will be adding more queries later. 

I am thinking I would need to make the values of $num_signage and 
$num_website into some sort of an array so flex can read individaul 
results.. I have have been trying many things with no success.

Any suggestions?

Thanks

$query_website = "SELECT form.question_id, form.answer_id, 
form.add_date, answer.answer_id, answer.answer FROM form
LEFT JOIN answer ON form.answer_id = answer.answer_id
WHERE form.question_id ='10' and answer.answer = 'Website' and 
form.add_date BETWEEN DATE '2008-06-01' AND DATE '2008-06-29'";
$result_website = mysql_query ($query_website);
$num_rows_website = mysql_num_rows($result_website);
$num_website = "<website_num>$num_rows_website</website_num>";
print ($num_website);

$query_signage = "SELECT form.question_id, form.answer_id, 
form.add_date, answer.answer_id, answer.answer FROM form
LEFT JOIN answer ON form.answer_id = answer.answer_id
WHERE form.question_id ='10' and answer.answer = 'Signage' and 
form.add_date BETWEEN DATE '2008-06-01' AND DATE '2008-06-29'";
$result_signage = mysql_query ($query_signage);
$num_rows_signage = mysql_num_rows($result_signage);
$num_signage = "<signage>$num_rows_signage</signage>";
print ($num_signage);