Here is my update query....all values are being sent to the page in the correct format for storage....although there are more columns in the actual table, I have placed them in the order they appear. All names are correct to the bast of my knowledge....
When I execute it I get: Couldn't execute query----update record....
$sql_update = "UPDATE staff_table
SET (surname='$surname', forename='$forename', e_mail='$e_mail', phone_ex='$phone_ex', mobile='$mobile', location_id='$location_id', home_town='$home_town', short_emp_hist='$short_emp_hist', interests='$interests')
WHERE staff_id='$staff_id'";
$sql_result = mysql_query($sql_update) or die ("Couldn't execute query----update record");
if (!$sql_result) {
echo "Couldn't add record!";
}
This is really starting to mess with my head....Please help...is there anything obviously wrong here.
