--- a/myway/myway_timeliness_route.php +++ b/myway/myway_timeliness_route.php @@ -22,9 +22,9 @@ <script language="javascript" type="text/javascript" src="../js/flot/jquery.flot.js"></script> <form method="get" action=""> - <select id="routeid" name="routeid"> + <select id="routename" name="routename"> <?php - $query = "select distinct route_full_name from myway_routes where myway_route != '' order by route_full_name"; + $query = "select distinct route_name from myway_timingdeltas order by route_name"; $query = $conn->prepare($query); $query->execute(); if (!$query) { @@ -32,7 +32,7 @@ return Array(); } foreach ($query->fetchAll() as $route) { - echo "<option value=\"{$route['route_full_name']}\">{$route['route_full_name']}</option>"; + echo "<option value=\"{$route['route_name']}\">{$route['route_name']}</option>"; }; ?> </select> <center><div id="placeholder" style="width:900px;height:550px"></div></center> @@ -59,12 +59,12 @@ // fetch one series, adding to what we got var alreadyFetched = {}; - $("#routeid").change(function () { + $("#routename").change(function () { var select = $(this); // find the URL in the link right next to us // var dataurl = button.siblings('a').attr('href'); - var dataurl = "myway_timeliness_route.json.php?routeid=" + select.val(); + var dataurl = "myway_timeliness_route.json.php?routename=" + select.val(); // then fetch the data with jQuery function onDataReceived(series) { // extract the first coordinate pair so you can see that