Update a record, but no update is done

eagle00789 · **Update a record, but no update is done -** 01-05-2005, 06: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");
}

Mighty_Y · 01-05-2005, 06:54 PM

Use this piece of code

Code:

function probs_agenda_edit_accept($pid, $datum, $tijd, $klantid, $description, $addby) {
   global $admin, $bgcolor2, $prefix, $db, $multilingual, $result;
   include ("header.php");
   GraphicAdmin();
   title("Problems - Agenda - Edit - Save");
   probs();
   OpenTable();
   $sql = "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";
   $db->sql_query($sql);
   echo "Agenda item bijgewerkt";
   echo "$sql";
   CloseTable();
   include("footer.php");
}

eagle00789 · 01-05-2005, 07:40 PM

thx Mighty_Y

Mighty_Y · 01-06-2005, 04:33 AM

np, glad it works