Php, Mysql

[GoogleCodeExporter]

Hello
I try to make a graph with a mysql query but I can't get a result, I tested 
several examples that I found on the net.
could you give an example for this query?

$query =mysql_query("select
               date_format(connect_time,'%Y-%m-%d %H %i') AS date,
               Customers.name as customer,
               Sum(duration) as secondes
               from CDR_Vendors
               inner join Customers on (CDR_Vendors.i_customer = Customers.i_customer)
               where
               i_vendor='32'
               and
               connect_time between '2010-09-13 00:00:00' and '2010-09-13 00:05:00'
               group by date
               ORDER BY date") or die(mysql_error());

Thank you.

Original issue reported on code.google.com by zexus.ze...@gmail.com on 15 Sep 2010 at 1:14

[GoogleCodeExporter]

Hi!

If you haven't figured it out already, try the forum/mailing list, this issue 
tracker is for actual bugs in Flot. The easiest way to do these things is 
generally to suck the data out into an array, then pass that through a JSON 
library.

Original comment by olau%iol...@gtempaccount.com on 14 Dec 2010 at 9:45

• Changed state: Invalid

[GoogleCodeExporter]

Original comment by dnsch...@gmail.com on 4 Jun 2012 at 2:39