Building data entry forms and reports for MySQL involves using HTML and a Web programming language such as PHP to create the front-end forms and reports, and using a database connection technology ...

No, you're not missing something, that is what was originally described as to-do. @MichaelC: the update statement with the case in it seems syntactically correct, but it updates ALL rows in the table, ...