All in one script: Connecting DB twice?

[Anon]

This is my first attempt at an all in one script like this, and I\'m doing something wrong.

I\'ve got fields with content from the DB, and then the DB can be updated. So it connects to the DB, user makes changes, press submit, check for required fields, run update script, get confirm message (all of this in one script). Problem...

This script skips right over the update part, and goes straight to confirm. Required fields check works fine.

I have tested this out with mailto instead of update DB, and it works. I\'ve also tested the update DB script on it\'s own, and it works.

Are there issues with connecting to a DB two times in one script? Any special code needed for this?

[Anon]

If your data base connection is something like

$dbconn = mysql_connect("localhost", "user", "passwd");

then you have to close this connection and re-open it before the second time you connect to the database. So, just before you connect to the database the second time you need

mysql_close($dbconn);

$dbconn = mysql_connect("localhost", "user", "passwd");

This worked for me when I had the same problem.