Hello,
Surely I am not the only one that is trying to do this but...
I am using php and mysql to view, delete and update/modify fields in a record.
I am not having a problem with viewing or deleting individual records.
However...
I need to be able to pull an individual record into a form, make a change on that form on possibly any number of fields and then submit the change. I am able to to pull the record from the table into the form, make the change but when I submit the record for updating and then re-view the record I just submitted nothing has changed. I am not sure at this point if it is my sql query or my php code.
My query for updating the change(s)is in the form:
$query="UPDATE my_table SET id=$id, field1=$field1, field2=$field2, field3=field3 WHERE id=$id ";
Do I need to list all the fields after the WHERE clause and not just the id field? Is the query correct and it is something in my php code?
If someone would like to answer this and need to see more code I can post it.
Thanks in advance!
Terry
