For getting error msg your php.ini should enable this line - error_reporting = E_ALL & ~E_NOTICE chk for this.
-=-=-=-=-=-=-=-=-=- @nkur [EMAIL PROTECTED] || http://ullu.wordpress.com -----Original Message----- From: Chris Carter [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 12:13 PM To: php-db@lists.php.net Subject: [PHP-DB] Where am I doing wrong - DB Just a small database code. Want to make entries in the mySQL table using PHP. Not being able to. When I run this code it takes me to the next blank brower window as if the entry has been made but after checking the database I do not find anything. There is not even an error message, I have tried two approaches this code is mixed. Please advice. <?php // database information Here was the database information removed for security. if($submit) { // connect and select the database $conn = mysql_connect($host, $user, $password) or die(mysql_error()); $db = mysql_select_db($dbName, $conn) or die(mysql_error()); // insert new entry in the database if entry submitted if($query_rows != 0) { $error = "THERE SOME ERROR TO BE SHOWN TO THE USER IF THE EMAIL ADDRESS EXISTS IN THE DATABASE"; } else{ /* $fName = $_POST['fName']; $lName = $_POSR['lName']; $email = $_POST['email']; $confEmail = $_POST['confEmail']; $password = $_POST['password']; $confirmPassword = $_POST['confirmPassword']; $address = $_POST['address']; $city = $_POST['city']; $state = $_POST['state']; $postCode = $_POST['postCode']; $gender = $_POST['gender']; $profession = $_POST['profession']; $ageGroup = $_POST['ageGroup']; $mallPref = $_POST['mallPref']; $mallConsent = $_POST['mallConsent'];*/ // insert new entry into database $sql = "insert data `userdata` (`fName`, `lName`, `email`, `confEmail`, `password`, `confirmPassword`, `address`, `city`, `state`, `postCode`, `gender`, `profession`, `ageGroup`, `mallPref`, `mailConsent`) VALUES ('$fName', '$lName', '$email', '$confEmail', '$password', '$confirmPassword', '$address', '$city', '$state', '$postCode', '$gender', '$profession', '$ageGroup', '$mallPref', '$mailConsent');"; $sucess_message = "SHOW HERE SOME MESSAGE TO THE USER IF THE ADDITION IS SUCESS"; } // end if new entry posted } Show some confirm or thank you HTML stuff. ?> Thank you in advance. Chris -- View this message in context: http://www.nabble.com/Where-am-I-doing-wrong---DB-tf2716628.html#a757418 7 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php The information contained in, or attached to, this e-mail, contains confidential information and is intended solely for the use of the individual or entity to whom they are addressed and is subject to legal privilege. If you have received this e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your system and notify your system manager. Please do not copy it for any purpose, or disclose its contents to any other person. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company. The recipient should check this e-mail and any attachments for the presence of viruses. The company accepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email. www.aztecsoft.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
