Changeset 17440 for schedule/Transaction


Ignore:
Timestamp:
01/03/14 15:48:52 (11 years ago)
Author:
tose
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • schedule/Transaction/update.php

    r17427 r17440  
    1818                        $days = Date('Y-m-d',strtotime($Gdates));
    1919                        $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."')");
    3321?>
Note: See TracChangeset for help on using the changeset viewer.