 <?php
//connect to the mysql
        $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($prev) > 0) {
      		$prevday = date('Y-m-d', strtotime($prevdate['PrevDate']));
        }
	else {
	      	$prevday = date('Y-m-d');
	}
	echo json_encode($prevday);
?>