Displaying values from a database (using mySQL) on a Flot graph

I'm trying to read in values from a db using php (mySQL) then have them show on a graph in flot. I know the values are read in correctly and I'm not getting any errors but the graph won't show. Little help?

Thanks in advance.

<?php
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    $graphdata[] =  array( (int)$row[0], (int)$row[1] );
}
?>
/////

<div id="p开发者_如何学运维laceholder" style="width:600px;height:300px"></div>

<script language="javascript" type="text/javascript">

var dataset1 = <?php echo json_encode($graphdata);?>;
var data = [
            {
                label: "Random Values",
                data: dataset1
            }
        ];
var plotarea = $("#placeholder");

        $.plot( plotarea , data);
</script>

---

The contents of your pastebin show that the JSON string you're outputting is invalid JSON.

var data = [{ label: "Random Values",data: dataset1}];

will validate if it's changed to:

var data = [{"label": "Random Values","data": "dataset1"}]

That's just an example, but I suspect that Flot is looking for a slightly different format, so you'll have to verify exactly what they're looking for against their documentation. I'm going through the same exercise right now with FusionCharts, so I'm feeling your pain. jsonlint.com is your friend on this one, output your JSON and verify it frequently. I'd also recommend that to initially get it working, start with just a string of JSON (even one that you copy from their examples) that you put right in your code. Get the chart working first, then work on getting your PHP to duplicate the example JSON string separately.

---

Try delaying creating the graph until the DOM is loaded:

jQuery(document).ready(function ($){
    var plotarea = $("#placeholder");
    $.plot( plotarea , data);
});