Check database entry

[Mr_Krabs]

Hi peoples,

german php-newbie need help.

I would like check a database entry after form submit.
I need a query to locate a double e-mail usage.

I have a script to send a form to the webmaster and register the
formresults in a mysql-database. This works fine. Now i need a
if/else instruction to locate a double e-mail use before register
the formresults.

After submit: If the email in this form existed in the database.
Message: E-Mail adress aready existing, if the email not in use
send mail and register.

Thanks for your help

<?php
include("global.inc.php");
$errors=0;
$error="Fehler sind aufgetreten !<ul>";
pt_register('POST','vorname');
pt_register('POST','name');
pt_register('POST','strasse');
pt_register('POST','plz');
pt_register('POST','ort');
pt_register('POST','email');
pt_register('POST','frage1');
pt_register('POST','frage2');
pt_register('POST','frage3');
if($vorname=="" || $name=="" || $strasse=="" || $plz=="" || 
$ort=="" || $email=="" || $frage1=="" || $frage2=="" || $frage3=="" ){
$errors=1;
$error.="<li>Sie haben nicht alle Felder ausgefüllt. Bitte 
versuchen Sie es nochmal.";
}
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-
z0-9]+)*)+"."\\.[a-z]{2,}"."$",$email)){
$error.="<li>Falsche oder fehlende E-Mail-Adresse";
$errors=1;
}
if($errors==1) echo $error;

else{
$where_form_is="http".($HTTP_SERVER_VARS["HTTPS"]
=="on"?"s":"")."://".$SERVER_NAME.strrev(strstr(strrev($PHP_SELF),"/"));
$message="Vorname: ".$vorname."
Name: ".$name."
Strasse: ".$strasse."
PLZ: ".$plz."
Wohnort: ".$ort."
E-Mail: ".$email."
Lösung Frage 1: ".$frage1."
Lösung Frage 2: ".$frage2."
Lösung Frage 3: ".$frage3."
";
$message = stripslashes($message);
mail("[e-mail]","Gewinnspiel",$message,"From:
$vorname $name");
$link = mysql_connect("host","user","pass");
mysql_select_db("database",$link);
$query="insert into gewinnspiel (vorname,name,strasse,plz,ort,email,frage1,frage2,frage3) values ('".$vorname."','".$name."','".$strasse."','".$plz."','".$ort."','"
.$email."','".$frage1."','".$frage2."','".$frage3."')";
mysql_query($query);
$make=fopen("admin/data.dat","a");
$to_put="";
$to_put .= $vorname."|".$name."|".$strasse."|".$plz."|".$ort."|".$email."|"
.$frage1."|".$frage2."|".$frage3."
";
fwrite($make,$to_put);

header("Refresh: 0;url=http://www.thankyou.htm");
?><?php 
}
?>

[Mr_Krabs]

No idea?

[madmada]

Sure. All you have to do is execute a query right after you check to see if the email submitted is a valid email address and before you check the $errors flag. Do a simple select looking for any records that have an email address matching the address that was provided.

 SELECT email FROM gewinnspiel WHERE email = "$email"

If you get any rows back at all from the query (you can just count them if you want...), the address was already registered. Set $errors = 1 and append a message on to $error saying that the email address submitted was already used.

Of course, you'll need to move the mysql_connect and the select_db lines up in the code to somewhere before you want to execute this query.

Cheers,
Adam

[Mr_Krabs]

Thanks Adam,

i check this tonight.

The database connect is no problem.
My problem is:

if (adress is availble) >>>> errror text
else >>>> go