Re: connecting to database..?

From: Date: Sun, 20 May 2001 16:40:11 +0000
Subject: Re: connecting to database..?
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-9476@lists.php.net to get a copy of this message
I have a strange situation-- I have a php page that submits form data to MySql database and sends an email confirmation on completion. It works fine, but there were several people at one site that although the emails indicate the data was submitted successfully, the data never showed up in the database. IS there a way that a specific IP can block MySql access? Curious, because now I have nearly a thousand datasets to manually enter. snip of code: $add_stmt = "update $tableName set name='$formUserName', category='$sections', title='$formWebsiteTitle', weblink='$formWebsiteURL', bannerlink='$formBannerURL', email='$formEmail' where num=$id"; if(!(mysql_query($add_stmt, $link))) { $message .= "\nERROR updating $tableName!<br><br>"; $message .= "sprintf($add_stmt, $sections)"; } else { $message .= "\nSuccessfully added record!"; } mail( $recpientList, $subject, $message, "From: $from "); Because the email indicates the record was successfully added, I believe it to be a problem with the IP v. MySql. Any suggestions?? Terry

« previous php.db (#9476) next »