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@[...].com]
Sent: Tuesday, November 28, 2006 12:13 PM
To: php-db@[...].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 a
nd is subject to legal privilege. If you have received this e-mail in error you should notif
y the sender immediately by reply e-mail, delete the message from your system and notify you
r system manager. Please do not copy it for any purpose, or disclose its contents to any oth
er 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 a
nd any attachments for the presence of viruses. The company accepts no liability for any dam
age 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