Invalid query: Duplicate entry '14' for key 3

[Hoangsta]

I don't have do while or any loop whatsoever in my code? do you think that is what i'm missing? do you guys need to see the code???

[jazappi]

please post some snippets so I can get a better clue.

[Hoangsta]

// Does not leave blank.
  if((!$cust_address) || (!$gen_city) || (!$generalacct_state_country) || (!$gen_zip) || (!$home_phone) || (!$business_type) || (!$business_name) || (!$business_address) || (!$bus_city) || (!$businessacct_state_country) || (!$bus_zip) || (!$business_phone)) {

// Validate business_phone
if (phone_namevalid($_POST['business_phone'] >= 10)) {

  $business_phone = strtolower($_POST['business_phone']);
  $business_phone = trim($business_phone);

  // Don't allow duplicate business_phone
$query = "SELECT customer_id 
		  FROM BusinessName 
		  WHERE business_phone = '$business_phone'";

  $result = mysql_query($query);
if ($result && mysql_num_rows($result) > 0)
	{
		$feedback = 'ERROR - Business already exists';
		return $feedback;  
 	} 
	else 
	{
		// Define post fields into simple variables from table Customer
		$cust_address = $_POST['cust_address'];
		$gen_city = $_POST['gen_city'];
		$generalacct_state_country = $_POST['generalacct_state_country'];
		$gen_zip =  $_POST['gen_zip'];
		$home_phone = $_POST['home_phone'];
		// Define post fields into simple variable from table BusinessName
		$business_type = $_POST['business_type'];
		$business_name = $_POST['business_name'];
		$business_address = $_POST['business_address'];
		$bus_city = $_POST['bus_city'];
		$businessacct_state_country = $_POST['businessacct_state_country'];
		$bus_zip = $_POST['bus_zip'];
		$business_phone = $_POST['business_phone'];
		$business_fax = $_POST['business_fax'];
		$webpagelink = $_POST['webpagelink'];


    // Insert into the db 
		$user_id = $_SESSION['user_id'];
   		$query = "INSERT INTO BusinessName (customer_id, business_type, business_name, business_address, bus_city, businessacct_state_country, bus_zip, business_phone, business_fax, webpagelink, date_created)  
		VALUES('$user_id', '$business_type', '$business_name', '$business_address', '$bus_city', '$businessacct_state_country', '$bus_zip', '$business_phone', '$business_fax', '$webpagelink', now())";

		$result = mysql_query($query) or die("<BR>Invalid query: " . mysql_error());

		$query = "INSERT INTO Customer (customer_id, cust_address, gen_city, generalacct_state_country, gen_zip, home_phone, date_created)
		VALUES('$user_id', '$cust_address', '$gen_city', '$generalacct_state_country', '$gen_zip', '$home_phone', now())";

		$result = mysql_query($query) or die("<BR>Invalid query: " . mysql_error());

    if (!$result) {
      $feedback = 'ERROR - Database error';
      return $feedback;
    } 
	else 
	{

  // Give a successful registration message
      $feedback = 'SUCCESS - Your information was stored! <br />';
      return $feedback;
    }
  }
} else {
  $feedback =  'ERROR - Missing required information! <br />';
  return $feedback;
}
  } else {
    $feedback = 'ERROR - There has been an error adding your business to our directory. Please contact the webmaster.';
    return $feedback;
  }
}