I won't beat around the bush. A simple form is posting the field "notes" and "request_id" to this script. "billingrequest" is my tablename, "notes" is the field on the table I wish to update with the field "notes", and requestid is the field on the table that identifies which row to update.
Here's the code:
<? include 'config.php'; $notes = $_POST['notes']; $request_id = $_POST['request_id']; $query = "UPDATE billingrequest SET notes = $notes". "WHERE requestid=$request_id"; echo $notes; echo $request_id; mysql_query($query) or die('Error, query failed'); ?>
I keep getting the error, 'Error, query failed'. What am I doing wrong? I've doublechecked the spellings of the fields and everything. Any ideas?