Problem solve Get help with specific problems with your technologies, process and projects.

PHP page works sometimes, not others

Weird problem. I have a form on a PHP page that collects three fields. When submit is selected, the data is sent to a second page where MySQL writes the data. But sometimes it works, and sometimes it doesn't. For new users who have not been entered into the database, sometimes it writes data successfully and other times it just gives me a 0 and no data is written. Any ideas what I should be looking at? I have six other databases running in the same environment that have never had this type of problem.

Well the first thing to do would be to look at the output of the mysql_error() function in PHP. This function will provide the textual error message from the MySQL server, which may shed some light on the problem. Another recommendation is to send this error message, along with any relevant information, to yourself with the mail() PHP function when an error is encountered. This may help identify trends.

One area to watch for is users violating primary keys or UNIQUE indexes. Before inserting the row, check and make sure the row is truly unique, or catch the error and ask the user for new information.

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.