Index: schedule/Transaction/update.php
===================================================================
--- schedule/Transaction/update.php	(revision 16926)
+++ schedule/Transaction/update.php	(revision 17422)
@@ -1,54 +1,33 @@
-
-<?php
-//Build by: khristofer Usman
-//Modified by: Jaypee Tanio
-// June 22,2013
-include '../include/factdb.php';
-$Time =$_POST['Time'];
-$SelectedSource = $_POST['Source'];
-$SelectedMeasure = $_POST['measure'];
-$limtex = count(explode(",",$SelectedSource));
-$Upd=$_POST['upd'];
-$Upt=$_POST['upt'];
-$value = $_POST['Data'];
-$date = $_POST['Date'];
-$n_value = explode(",",$value);
-$Times = explode(",",$Time);
-$select = explode(",",$SelectedSource);
-$measure = explode(",",$SelectedMeasure);
-//date_default_timezone_set('Asia/Manila'); // Setting up the localTimeZone in asia
-$UpdateDate=(date('Y-m-d H:i:s'));
+ <?php
+//connect to the mysql
+$db = mysql_connect('localhost', 'root', '') or die("Could not connect database");
+mysql_select_db('sandboxschedule', $db) or die("Could not select database");
 
 
-						$days = Date('Y-m-d',strtotime($date));
+	$GTimes=$_POST['GTime'];
+	$Source=$_POST['Source'];
+	$measure=$_POST['measure'];
+	$data=$_POST['Data'];
+	$Gdates = $_POST['GDate'];
+	$seq = $_POST['seq'];
+	
+	$date = new DateTime($Gdates.$GTimes);
+	$par=$date->format('Y-m-d H:i:s');
+	$UpdateDate=(date('Y-m-d H:i:s'));
 
-			$fetch = mysql_query("SELECT * FROM schedule") or die(mysql_error());
-					
-					while($rows = mysql_fetch_array($fetch))
-					{
-					$timestamp=strtotime($rows['fStart']);
-					$timestamp2 = date('Y-m-d',$timestamp);
-					$date_time = date('H:i',$timestamp);
-					//$time_new = $date_time->format('H:i:s')
-						if($days == $timestamp2)
-						{
-
-						$delete = mysql_query("DELETE FROM `schedule` WHERE `fStart`='{$rows['fStart']}'");
+			$days = Date('Y-m-d',strtotime($Gdates));
+			$cnt = 0;
+			//QUERY TO DELETE THE TABLE INSIDE THE DATABASE
+			//$fetch = mysql_query("SELECT * FROM schedule WHERE date(fStart)='$days'") or die(mysql_error());			
+			//while($rows = mysql_fetch_array($fetch)){
+				//$update=mysql_query("UPDATE schedule SET `fStart`='$par',`fLastUpdate`='$UpdateDate',`fMeasurementID`='$seq',`fData`='$data',`fSourceKey`='$Source',`fMeasurementTypeKey`='$measure' WHERE fScheduleID = '".$rows['fSchecduleID']."' ");
+				
+				//mysql_query("DELETE FROM schedule WHERE date(fStart)='".$rows['fStart']."'");
+				mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$UpdateDate."','".$seq."','','".$data."','".$Source."','".$measure."')");
+			//}	
 			
-						}
-					}
-					
-
-for($i=0;$i<=$limtex-1;$i++)
-{
-$select = explode(",",$SelectedSource);
-	$n1 = $n_value[$i];		
-	$selectf = $select[$i];	
-	$measuref = $measure[$i];
-	$dateTime=new DateTime($date." ".$Times[$i]);
-	$parsed_date =  $dateTime->format('Y-m-d H:i:s');
+			
+				//$delete = mysql_query("DELETE FROM `schedule` WHERE `fStart`='{$rows['fStart']}'");
+			//database query
 	
-		mysql_query("INSERT INTO schedule VALUES('null','".$parsed_date."','".$UpdateDate."','".$measuref."','','".$n1."','".$selectf."','".$measuref."')");	
-			
-}	
 ?>