[thelist] MySQL/PHP DWMX Duplicate Entry Error Question

[Liam Delahunty]

Phil Parr wrote:

>I'd like to be able to display a message like "Sorry - this email
>address is already in use" and provide a link back to the form.

On submit (and after any form validation) just look up the email address
from the table...

$query = "SELECT email FROM that_tbl WHERE email = '$email' ";
$num_rows = mysql_num_rows($result);
if ($num_rows) {
	print ("Sorry - this email address is already in use");
	} else {
	$query = "INSERT INTO .... ";
	$result = mysql_query($query, $connection);
}


Kind regards,
Liam Delahunty
Mega Products Limited, http://www.britstream.com/
Hosting/ Domain Names From UKP 7.50 p.a.
web/ design/ database/ programming