RE: Where am I doing wrong - DB

["Ankur Dave" <ankurd@xxxxxxxxxxxxx>]

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