make PHP page load regardless mySQL

[bookbuyer2000]

I have a PHP page with a mySQL insert statement at the top. If there's any mySQL problem (e.g. locked tables, database error, etc.), I'll only get a blank page in my web browser.

How do I code it so that whether or not there are mySQL errors, the PHP page will still load normally?

I tried moving the mySQL coding to the bottom of the page, after the final "</HTML>" tag... but that didn't help.

Thank you!!

[halojoy]

hi!

You are able to post your php page?
And use the 'php' '/php' bbcode tags, around your code.

It would make it possible to get the situation better for to figure out the help.

Because this, I feel, is an easy case.
For some of our best 'helpers.

Regards 🙂

[bookbuyer2000]

Thank you for replying. Actually, it's just a simple html page with mysql at the top:

$link=mysql_connect(blah blah blah)
then mysql insert statement
...then an html page.

But, if I force a mysql error (like go in and lock the table, etc., or, if for some reason I shut the mysql server down), the rest of the page won't load.

Is there a way to code it (like, "if mysql error, skip/ignore the query and continue loading the html page").

[schwim]

sure, but since you seem reluctant to post your code, the best we can do to help is to suggest that you alter any db query that demands that the script"die", to.... well, not die.

MySQL statements are often written to kill the script in case of error since most scripts rely on the data being pulled from the db.

thanks,
json