[Alith7]

I have a database with 2 UNIQUE columns for phone and email.
it's working to block duplicate entries, however I'm having a problem managing the error message to something that will make sense to the user.

Here is the code I have so far.

PHP Code:

<?php

$dbinsert = false;



$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}



// sest store location to dictate which table to post to

$storetable = $_POST['store'];



if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "regForm")) {

  $insertSQL = sprintf("INSERT INTO {$storetable} (first_name, last_name, email, phone) VALUES (%s, %s, %s, %s)",

                       GetSQLValueString($_POST['first_name'], "text"),

                       GetSQLValueString($_POST['last_name'], "text"),

                       GetSQLValueString($_POST['email'], "text"),

                       GetSQLValueString($_POST['phone'], "text"));



  mysql_select_db($database_Registration, $Registration);

  $Result1 = mysql_query($insertSQL, $Registration) or die(mysql_error());



  $insertGoTo = $_SERVER['PHP_SELF'];

  if (isset($_SERVER['QUERY_STRING'])) {

    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

    $insertGoTo .= $_SERVER['QUERY_STRING'];

  }

  header(sprintf("Location: %s", $insertGoTo));

}



?>

How do I overwrite the default error message with one that would use something like this to plug back into the page

PHP Code:

if ($Result1) {

     $dbinsert = true;

     }

if (!$Result1) {

     $error['already_reg'] = 'The email or phone that you entered is already registered.  You can only enter once.  If you feel that this is an error, please contact the webmaster at bugs@digitaledgecc.com.';

     } 

help?

[Alith7]

and, on top of all that....

how would you post to a DB at the same time as sending a mail script? I can't seem to get it to do both at the same time. I can get it to do one or the other.