I'm trying to help a friend with php but I don't know it very well. They are having problems trying to insert, update and delete. All of the selects work fine. They took this site over from someone else and it used to work perfect. Does anyone know why this might be happening?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
PHP AND MYSQL problems
- Thread starter slatet
- Start date
sleipnir214
Programmer
Insufficient data for a meaningful answer.
"Having problems" is vague. What is happening?
Is your friend trying to make the site do something new and it's failing, or is this something the site has always had problems with?
Are there any errors being generated?
Want the best answers? Ask the best questions!
TANSTAAFL!!
"Having problems" is vague. What is happening?
Is your friend trying to make the site do something new and it's failing, or is this something the site has always had problems with?
Are there any errors being generated?
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Thread starter
- #3
The application has supposedly always worked so they are trying to get it to work again. When you try to do an update insert or delete, the page acts like it is processing the data, but no changes are ever made to the db and no errors are generated. It acts like it is working, but does not.
sleipnir214
Programmer
Again, insufficient data for a meaningful answer.
The only thing I can recommend, given that you haven't even specified what database backend the script uses, is[ul][li]to fingerprint your code by outputting variables all through the script and [/li][li]verify that variables used in conditions have the values you think they do[/li][/ul]
Want the best answers? Ask the best questions!
TANSTAAFL!!
The only thing I can recommend, given that you haven't even specified what database backend the script uses, is[ul][li]to fingerprint your code by outputting variables all through the script and [/li][li]verify that variables used in conditions have the values you think they do[/li][/ul]
Want the best answers? Ask the best questions!
TANSTAAFL!!
TrojanWarBlade
Programmer
Sounds like it could be a permissions (grants) problem.
Does the user you login in to the DB have insert and update rights?
It also sounds like the code doesn't trap errors very well. A failure to insert or update should generate some kind of error and be trapped.
Trojan.
Does the user you login in to the DB have insert and update rights?
It also sounds like the code doesn't trap errors very well. A failure to insert or update should generate some kind of error and be trapped.
Trojan.
- Status