View Single Post
Update a record, but no update is done
Old
  (#1 (permalink))
eagle00789
Junior Member
 
Status: Offline
Posts: 20
Join Date: Dec 2004
Update a record, but no update is done - 01-05-2005, 05:40 PM

i update a record in mysql with the code below, but the selected record is not being updated. What did i do wrong with this code??
Code:
function probs_agenda_edit_accept($pid, $datum, $tijd, $klantid, $description, $addby) {
   global $admin, $bgcolor2, $prefix, $dbi, $multilingual, $result;
   include ("header.php");
   GraphicAdmin();
   title("Problems - Agenda - Edit - Save");
   probs();
   Opentable();
   $result = $db->sql_query("UPDATE ".$prefix."_probs_agenda SET datum='".date("Y-m-d", strtotime($datum))."', tijd='$tijd', 

klantid='$klantid', description='$description', addby='$addby' where id='$pid' LIMIT 1", $dbi);
   echo "Agenda item bijgewerkt";
   echo "$result";
   closetable();
   include("footer.php");
}
   
Reply With Quote