Changeset 16101 for schedule

Timestamp:

05/23/13 22:57:10 (11 years ago)

Author:

tanio

Message:

 

File:

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

schedule/Transaction/insert.php

@@ -66 +66 @@
                                                 
                                         
-                        // $select = mysql_query("SELECT * FROM schedule WHERE fLastUpdate = '$parsed_date'");
-                        // if($select){
-                        // while($row = mysql_fetch_array($select)){
+                        $select = mysql_query("SELECT * FROM schedule WHERE fLastUpdate = '$parsed_date'");
+                        if($select){
+                        while($row = mysql_fetch_array($select)){
                 
                                 
-                                // $new =   $row['fMeasurementID'] + 1 ;
+                                $new =   $row['fMeasurementID'] + 1 ;
                                 
                         
                         
-                        // }
-                                // }else{
+                        }
+                                }else{
                                 
-                                // $new = 0;
+                                $new = 0;
                                 
-                                // }    
+                                }       
                                 //echo $new."<br />";
                         
-                $insert = mysql_query("INSERT INTO schedule values('','$parsed_date','$parsed_date','','','$n1','$selectf','$measuref')ON DUPLICATE KEY UPDATE fMeasurementID=fMeasurementID + 1") or die(mysql_error());
+                $insert = mysql_query("INSERT IGNORE INTO schedule values('','$parsed_date','$parsed_date','$new','','$n1','$selectf','$measuref')") or die(mysql_error());
                                         
 }