Assuming $submit even has a value (Are you sure you don't mean $_POST['something'] here?) all your code does is test 2 variables, connect to the server, change to a database and set some more few variables. When do you plan to execute a query "mysql_query($sql)", or output a print or echo of some text or HTML? "or die" doesn't output anything because $submit is probably false. Your page should be blank and nothing should go to the database with this code. Regards, Dwight x2407 > -----Original Message----- > From: Ankur Dave [mailto:ankurd@xxxxxxxxxxxxx] > Sent: Tuesday, November 28, 2006 1:01 AM > To: Chris Carter; php-db@xxxxxxxxxxxxx > Subject: RE: Where am I doing wrong - DB > > > For getting error msg your php.ini should enable this line - > error_reporting = E_ALL & ~E_NOTICE > chk for this. > > -=-=-=-=-=-=-=-=-=- > @nkur d@ve || http://ullu.wordpress.com > > > -----Original Message----- > From: Chris Carter [mailto:chandan9sharma@xxxxxxxxx] > Sent: Tuesday, November 28, 2006 12:13 PM > To: php-db@xxxxxxxxxxxxx > Subject: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
