but whatever the value i enter the first statement execute
kindly guide me how to resolve it
Code: Select all
$nic= mysqli_real_escape_string($link, $_POST['nic']);
$contact= mysqli_real_escape_string($link, $_POST['contact']);
$company= mysqli_real_escape_string($link, $_POST['company']);
if("SELECT * FROM userdata WHERE nic = '".$_POST['nic']."'")
{
echo("Same employee details has already been saved"));
}
else
{
$sql = "INSERT INTO userdata (first_name,last_name,email_address,age,gender,degree,university,otheruniversity,address,nic,contact,company)
VALUES ('$first_name','$last_name','$email_address','$age','$gender','$degree','$university','$otheruniversity','$address','$nic','$contact','$company' )";
if(mysqli_query($link, $sql))
{
$_SESSION['id'] = mysqli_insert_id($link);
header("location: quizenglish.php");
}
}
mysqli_close($link);