Changeset 17441 for schedule/Transaction/delete.php

Timestamp:

01/03/14 15:49:04 (11 years ago)

Author:

tose

Message:

 

File:

• schedule/Transaction/delete.php (modified) (1 diff)

schedule/Transaction/delete.php

@@ -6 +6 @@
                 
                 //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']."' ");
-                        
+                /*$fetch = mysql_query("SELECT * FROM schedule WHERE date(fStart)='$days'") or die(mysql_error());                      
+                while($rows = mysql_fetch_array($fetch)){               
                         mysql_query("DELETE FROM schedule WHERE `fStart`='".$rows['fStart']."'");
-                        //mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$UpdateDate."','".$seq."','','".$data."','".$Source."','".$measure."')");
-                }       
+                }       */
+                mysql_query("DELETE FROM schedule WHERE DATE(fStart)= '" + $days + "'");
 ?>