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
