Untitled

<html>
<head>
<script language="javascript" type="text/javascript" src="js/jquery.js"></script>
<script language="javascript" type="text/javascript" src="js/flot/jquery.flot.js"></script>
</head>
<body>
<div id="placeholder" style="width:600px;height:300px;"></div>

<?php


$server = "localhost";
    $user="turutimo";
    $password="turutimo";
    $database = "user_turutimo";


	$start ="01";
	$end ="31";
   $connection = mysql_connect($server,$user,$password);
    $db = mysql_select_db($database,$connection);
        $result = mysql_query("SELECT * FROM A2_projekti ORDER BY aikaleima DESC LIMIT 5");
    //  $result = mysql_query("SELECT * FROM A2_projekti WHERE aikaleima >=  '2012-03-29' ORDER BY aikaleima DESC");


        while($row = mysql_fetch_assoc($result))
    {
                // antaa kellonajan timestampistä
                echo date('l, F d, Y, H.i', strtotime($row['aikaleima'])) .' - Lampotila: '. $row['lampotila'].'C  <br />';
                $dataset1[] = array(date('H.i', strtotime($row['aikaleima'])),$row['lampotila']);
    }

?>


<script type="text/javascript">
$(function () {
    var dataset1 = <?php echo json_encode($dataset1); ?>;

    $.plot($("#placeholder"), [ dataset1 ]);
});
</script>
 </body>
</html>