How to retrieve data from mysql database to plot jquery flot graph

[sarah aziz]

Hello all
I am trying to retrieve the data from mysql database by php to plot a flot graph can anyone help me please this is all i have done for now
Php

$sql = mysql_query("SELECT count(Msg_ID) msgCount,Group_ID 
                                      FROM Messages 
                                        GROUP BY Group_ID");
 
$dataset1 = array();
 
 
    while ($row = mysql_fetch_assoc($sql)) 
    {
        $dataset1[] = array( $row['msgCount'], $row['Group_ID'] );
    }
 print_r($dataset1);
 
jquery
    function plotGraph()
    {
        alert("In body");
        $.ajax({
            url:"getData.php",
            type:"post",
            datatype:"json",
            success:function(data)
            {
            $.plot($("#placeholder"), [ data ]);
           },
            error:function()
            {alert("There was a problem");}
        })
    }

This draws the place holder but with no lines

[Markus]

What do you get if you alert(data) in your success function. What kind of data does the plot need?

[sarah aziz]

I am just testing by count of messages for each group, so i guess it is integer
is that what you are asking for