So I was doing my edit page for my html form, however it is not updating the database and it always show me error message update fail. I was wondering if there is any error in my codes or query.
This is my query
$queryupdate = "Update anno
SET where id = '$no'
and title = '$row' and serial_no = '$no'
and type = '$type' and anno = '$row1' ";
Your query syntax is wrong:
UPDATE tableName SET columnToModify = newValue WHERE coniditons;
in your case you did not specify the column to be modified and jumped ahead to the condition.
Are you doing like that ?
$queryupdate = "Update anno
SET title = '$row' and serial_no = '$no'
and type = '$type' and anno = '$row1' where id = '$no'
";