I'm kinda new to php and I set up the phpFormGenerator on my home server as a testing system before I publish. My problem that I am having is that after I have rows of information and want to delete one of the rows I click delete it gives me a confirmation of deletion, but when I go back to it, it hasn't deleted. Even when I refresh it is still there. When I look in my mysql database on my local server, I see that no it has not deleted. Any ideas why?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
well, it can mean one of two things. There can be a bug in the program, which is making it generate a bad SQL query for deleting the record. Or, it maybe that the user information that you provided to access the database doesn't have delete permissions on the database. Try the latter first, if that isn't the problem let me know. I'm pretty sure the queries are correct because I have not recieved any problem reports of this sort.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm kinda new to php and I set up the phpFormGenerator on my home server as a testing system before I publish. My problem that I am having is that after I have rows of information and want to delete one of the rows I click delete it gives me a confirmation of deletion, but when I go back to it, it hasn't deleted. Even when I refresh it is still there. When I look in my mysql database on my local server, I see that no it has not deleted. Any ideas why?
well, it can mean one of two things. There can be a bug in the program, which is making it generate a bad SQL query for deleting the record. Or, it maybe that the user information that you provided to access the database doesn't have delete permissions on the database. Try the latter first, if that isn't the problem let me know. I'm pretty sure the queries are correct because I have not recieved any problem reports of this sort.
try the search: "MySQL delete". Had the same problem here and there is a fix.