Problem with Update statement
Posted: Mon Dec 13, 2004 8:49 am
Hi ppl
Im having a few problmes when it comes to updating my data, once i have entered the data i wish to update and click submit it does not submit the data from taskdesc or nextstep!
I think this may have something to do with the fact that both of these fields are textareas in my form any ideas?
Im having a few problmes when it comes to updating my data, once i have entered the data i wish to update and click submit it does not submit the data from taskdesc or nextstep!
I think this may have something to do with the fact that both of these fields are textareas in my form any ideas?
Code: Select all
<?
//display the info you want to edit in textboxes.
//after it has been submitted do this:
$query = "UPDATE `pcr` SET `PCRTitle` = '". $_POSTї"pcrtitle"] ."', `RaisedBy` = '". $_POSTї"raisedby"] ."', `taskdesc` = '". $_POSTї"taskdesc"] ."', `Status` = '". $_POSTї"status"] ."', `NextStep` = '". $_POSTї"nextstep"] ."', `Engineer` = '". $_POSTї"engineer"] ."', `PCRDate` = '". $_POSTї"pcrdate"] ."' WHERE `pcrid` = '$pcrid'";
$result = mysql_query($query);
echo("<SCRIPT LANGUAGE='JavaScript'>
window.alert('PCR Has Been Updated')
</SCRIPT>");
?>