[flexcoders] populating a column chart with php and 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 here is an example of my php code

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


I would like to have $num_signage and $num_website as datagrid 
columns.


Any suggestions?

Thanks