I've been up so long on this I cant read the text anymore. Please help: *Here's the html:*
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";> <html> <head> <title>RealShortData.Com</title> <meta http-equiv="Content-type" content="text/html; charset=utf-8" /> <!--Load the Ajax API--> <script type="text/javascript" src="https://www.google.com/jsapi";></script> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js";></script> <script type="text/javascript"> google.load('visualization', '1', {'packages':['corechart','geochart','table']}); // Set a callback to run when the Google Visualization library is loaded. google.setOnLoadCallback(drawChart); function drawChart() { var jsonData = $.ajax({ url: "functions/json30.php", dataType: "json", async: false }).responseText; var data = new google.visualization.DataTable(JSON.parse(jsonData); var options = { title: 'Short Volume Percentage Breakdown' }; var chart = new google.visualization.LineChart(document.getElementById('chart_div')); chart.draw(data, options); } </script> <style type="text/css"> body { background-color: #f0f0f2; margin: 0; padding: 0; font-family: "Open Sans", "Helvetica Neue", Helvetica, Arial, sans- serif; } a:link, a:visited { color: #38488f; text-decoration: none; } </style> </head> <header> <divid="headerdiv"> <h1>RealShortData.com</h1> <p>Coming Soon!</p> <img src="includes/bar1.png" style="float:center"> </div> <br> </br> <divid="searchdiv"> <h3>Short Volume & Dark Pool Volume Search</h3> <form method="GET" action="<?php echo $_SERVER['PHP_SELF']; ?>" > Enter Ticker Symbol: <input type="text" name="query" /> <input type="submit" value="Search" /></form> <img src="includes/bar1.png" style="float:center"> </div> </header> <?php include("functions/json30.php"); ?> <body> <div id="chart_div" style="width: 900px; height: 500px;"></div> </body> </html> *And the php* <?php include("includes/connect.php"); //include("linechart30.php"); $query = $_GET['query']; $query = strtoupper($query); $query = htmlspecialchars($query); $query = mysql_real_escape_string($query); $chrt30dtsp= "SELECT `date`, `open_short_percent` , `total_short_percent` FROM `tsp30d` WHERE `symbol` = '$query' ORDER BY `date` ASC"; $result = mysql_query($chrt30dtsp); $table = array(); $table['cols'] = array( array('label' => 'date', 'type' => 'date'), array('label' => 'Open Short Pct', 'type' => 'number'), array('label' => 'Total Short Pct', 'type' => 'number') ); $rows = array(); while($r = mysql_fetch_assoc($result)) { $temp = array(); $temp[] = array('v' => $r['date']); $temp[] = array('v' => (float) $r['open_short_percent']); $temp[] = array('v' => (float) $r['total_short_percent']); $rows[] = array('c' => $temp); } $table['rows'] = $rows; $jsonData = json_encode($table); echo $jsonData; ?> *and the result set:* RealShortData.com Coming Soon! Short Volume & Dark Pool Volume SearchEnter Ticker Symbol: {"cols":[{"label":"date","type":"date"},{"label":"Open Short Pct","type":"number"},{"label":"Total Short Pct","type":"number"}],"rows":[{"c":[{"v":"2014-10-20"},{"v":50.28},{"v":43.92}]},{"c":[{"v":"2014-10-21"},{"v":48.84},{"v":52.51}]},{"c":[{"v":"2014-10-22"},{"v":62.18},{"v":52.88}]},{"c":[{"v":"2014-10-23"},{"v":74.94},{"v":138.07}]},{"c":[{"v":"2014-10-27"},{"v":78.98},{"v":16.18}]},{"c":[{"v":"2014-10-28"},{"v":54.11},{"v":39.22}]},{"c":[{"v":"2014-10-29"},{"v":58.77},{"v":57.33}]},{"c":[{"v":"2014-10-30"},{"v":43.02},{"v":41.5}]},{"c":[{"v":"2014-10-31"},{"v":61.03},{"v":54.9}]},{"c":[{"v":"2014-11-03"},{"v":52.6},{"v":69.08}]},{"c":[{"v":"2014-11-05"},{"v":66.67},{"v":58.63}]},{"c":[{"v":"2014-11-06"},{"v":48.44},{"v":47.81}]},{"c":[{"v":"2014-11-07"},{"v":48.57},{"v":43.04}]},{"c":[{"v":"2014-11-10"},{"v":53.45},{"v":42.73}]},{"c":[{"v":"2014-11-11"},{"v":62.89},{"v":64.35}]},{"c":[{"v":"2014-11-12"},{"v":67.48},{"v":69.58}]},{"c":[{"v":"2014-11-13"},{"v":58.34},{"v":62.46}]},{"c":[{"v":"2014-11-14"},{"v":54.91},{"v":54.93}]},{"c":[{"v":"2014-11-17"},{"v":48.75},{"v":36.2}]}]} I'm stuck and exhausted///please help// Thank you in advance..... -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
