-1

This is my code. I want to validate email. If enter email double redirect sorry.php page. This code worked in localhost. But when I upload into the server. It does not work.

<?php include "db.php";

$fblood=$_POST["blood"];
$fname=$_POST["name"];
$femail=$_POST["email"];
$fpassword=$_POST["password"];
$fdistrict=$_POST["district"];
$farea=$_POST["area"];
$fcontact=$_POST["contact"];
$fstatus=$_POST["status"];
$ffacebook=$_POST["facebook"];
$flastdate=$_POST["lastdate"];
$fextra=$_POST["extra"];

$sql = "SELECT count(*) FROM signup WHERE email = '$femail' AND 
password ='$fpassword' LIMIT 1";

$result = mysql_query($sql) or die(mysql_error());

if (mysql_result($result, 0) > 0){


        header('Location: sorry.php');
}

elseif (mysql_result($result, 0) < 1)

    {

    // $query_auto = "INSERT INTO form (date, time) VALUE ('DATE: Auto CURDATE()', CURDATE() )";


mysql_query("INSERT INTO signup(`id`, `blood`, `name`, `email`, `password`, `district`, `area`, `contact`, `status`, `facebook`, `lastdate`, `extra`) 
            VALUES(NULL,'$fblood','$fname','$femail','$fpassword', '$fdistrict', '$farea', '$fcontact', '$fstatus', '$ffacebook', '$flastdate', '$fextra' )") or die(mysql_error());
    header('Location: congratulations.php');
}
?>
S M Nahidur Rahman
  • 39
  • 7

1 Answers1

0

problem solved. Just a space problem. elseif to else if

S M Nahidur Rahman
  • 39
  • 7