Index: schedule/Transaction/PreviousData.php
===================================================================
--- schedule/Transaction/PreviousData.php	(revision 17549)
+++ schedule/Transaction/PreviousData.php	(revision 17551)
@@ -1,16 +1,19 @@
  <?php
 //connect to the mysql
-	include '../include/dbcon.php';
-	$day=$_POST['SelectedDay'];
-	
+        $db = mysql_connect("localhost","scheduletest","t3stsched");
+	mysql_select_db('sandboxschedule', $db) or die("Could not select database");
+
+        $day=$_POST['SelectedDay'];
 	$date = Date('Y-m-d', strtotime($day));
-	$prev = mysql_query("SELECT Date(fStart) AS PrevDate FROM schedule WHERE (date(fStart) < $date) ORDER BY Date(fStart) DESC LIMIT 1");
-	$prevdate = mysql_fetch_array($prev);
-  	if(mysql_num_rows($prevdate) > 0) {
-      $prevday = date('Y-m-d', $prevdate['PrevDate']);
-  	} 
+
+       	$prev = mysql_query("SELECT Date(fStart) AS PrevDate FROM schedule WHERE (Date(fStart) < '$date') ORDER BY Date(fStart) DESC LIMIT 1");
+        $prevdate = mysql_fetch_array($prev);
+
+        if(mysql_num_rows($prev) > 0) {
+      		$prevday = date('Y-m-d', strtotime($prevdate['PrevDate']));
+        }
 	else {
-      $prevday = date ('Y-m-d');
+	      	$prevday = date('Y-m-d');
 	}
-	echo $prevday;
+	echo json_encode($prevday);
 ?>