Start of myway timeliness graphing
[busui.git] / include / db / stop-dao.inc.php
blob:a/include/db/stop-dao.inc.php -> blob:b/include/db/stop-dao.inc.php
--- a/include/db/stop-dao.inc.php
+++ b/include/db/stop-dao.inc.php
@@ -81,7 +81,7 @@
 function getStopsByStopCode($stop_code,$startsWith = "")
 {
 	global $conn;
-	$query = "Select * from stops where stop_code = :stop_code OR stop_code LIKE :stop_code2";
+	$query = "Select * from stops where (stop_code = :stop_code OR stop_code LIKE :stop_code2)";
                 if ($startsWith != "") $query .= " AND stop_name like :startsWith";
 
 	debug($query, "database");
@@ -105,7 +105,7 @@
 {
 	if ($service_period == "") $service_period = service_period();
 	global $conn;
-	$query = "SELECT service_id,trips.route_id,route_short_name,route_long_name
+	$query = "SELECT distinct service_id,trips.route_id,route_short_name,route_long_name
 FROM stop_times join trips on trips.trip_id =
 stop_times.trip_id join routes on trips.route_id = routes.route_id WHERE stop_id = :stopID AND service_id=:service_period";
 	debug($query, "database");