Changeset 17440 for schedule/Transaction
- Timestamp:
- 01/03/14 15:48:52 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
schedule/Transaction/update.php
r17427 r17440 18 18 $days = Date('Y-m-d',strtotime($Gdates)); 19 19 $cnt = 0; 20 //QUERY TO DELETE THE TABLE INSIDE THE DATABASE 21 //$fetch = mysql_query("SELECT * FROM schedule WHERE date(fStart)='$days'") or die(mysql_error()); 22 //while($rows = mysql_fetch_array($fetch)){ 23 //$update=mysql_query("UPDATE schedule SET `fStart`='$par',`fLastUpdate`='$UpdateDate',`fMeasurementID`='$seq',`fData`='$data',`fSourceKey`='$Source',`fMeasurementTypeKey`='$measure' WHERE fScheduleID = '".$rows['fSchecduleID']."' "); 24 25 //mysql_query("DELETE FROM schedule WHERE date(fStart)='".$rows['fStart']."'"); 26 mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$UpdateDate."','".$seq."','','".$data."','".$Source."','".$measure."')"); 27 //} 28 29 30 //$delete = mysql_query("DELETE FROM `schedule` WHERE `fStart`='{$rows['fStart']}'"); 31 //database query 32 20 //mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$UpdateDate."','".$seq."','','".$data."','".$Source."','".$measure."')"); 33 21 ?>
Note:
See TracChangeset
for help on using the changeset viewer.