While following a tutorial on updating a database with ajax, I encountered a situation where the tutorial wanted to create a new row for each update, but I needed to update an existing row instead. I managed to modify the code to suit my requirements, but now I want to update more than one column in the same row.
My form includes two values: Show Announcement and Announcement Content. In the text field, I can update Show Announcement to either 0 or 1 (true or false), and in Announcement Content, I can input the desired text.
The issue arises when I try to add
&& isset($_POST['anncontent']) && $_POST['anncontent']!=''if statement at line 19 (marked within the code) and include another SET option in the variable $sql (SET announcement=('".addslashes($_POST['anncontent'])."')Here is the relevant snippet from submit.php:
<?php
// PHP code snippet
In my index.php, the form layout allows me to update both fields as required:
// HTML code snippet
I suspect that there might be an issue with my SQL query. I attempted adding another $sql call with only the SET announcement clause, but it did not resolve the problem, leading to the same error code.
When attempting to update only the Show Announcement field, I receive an "Error While Updating" message, whereas trying to update both fields leaves me stuck with an "Updating..." message displayed without progress. You can view a screenshot of the page here.
If additional information is required to diagnose the issue, please let me know.