无法更新我的数据库

Question

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' ";

Answer 1

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.