Required Fields

Mark

i need some help, why doesnt this work? can anyone help?
ok, i have people send info to the database for registration, then if they dont fill in the required fields i dibt want the info sent, heres what i have.. it does tell them to go back and fill in the info, but it still sends the incorrect data to the database.

$result = mysql_query ("INSERT INTO biohazard_users (username, passwd, firstname, lastname, email, age, homepage, imservicename, aim, yahoo, icq) 
                VALUES ('$username', '$passwd', '$firstname', '$lastname', '$email', '$age', '$homepage', '$imservicename', '$aim', '$yahoo', '$icq')"); 
if(empty($username) || empty($passwd) || empty($firstname) || empty($lastname) || empty($email))
{
mysql_close($db); 
die("
Please fill in the required(<font color=#446bac>*</font>) forms. <a href=\"/?bh=register\">Go Back.</a>
</td>

cahva

Could you be more specific? What do you mean by saying that it sends 'incorrect' info. Does it put anything in the db?

lastuser

I am not sure is problem this, but if must be before the $result. Your script first put data to the database and after it will test is there any problem.

rIkLuNd

Just like lastuser said above:

if(empty($username) || empty($passwd) || empty($firstname) || empty($lastname) || empty($email))
{
mysql_close($db); 
die("
Please fill in the required(<font color=#446bac>*</font> ) forms. <a href=\"/?bh=register\">Go Back.</a>
</td>
}
else
{
$result = mysql_query ("INSERT INTO biohazard_users (username, passwd, firstname, lastname, email, age, homepage, imservicename, aim, yahoo, icq)
VALUES ('$username', '$passwd', '$firstname', '$lastname', '$email', '$age', '$homepage', '$imservicename', '$aim', '$yahoo', '$icq')"); 
}

?>

Mark

thanx, i figured it out, just needed the if statment in front😃