I am hoping someone could enlighten me if what I am hoping to accomplish was possible or provide me a suggestion to my task.
I am trying to update a few rows in a table where the same column has values of 'X', 'Y', and 'Z'.
SET nShow = 1
WHERE houses_id=3 AND houses_id=5 and houses_id=7;
I have a form with a number of house pictures, and each house picture has a check box. The user checks the boxes of the houses they want displayed, and presses the submit form button. Upon form submission, the query would update the field 'nShow' = 1 for the houses that should be displayed...