SQL error

[einSTein]

i have a problem with that code , this code enters the data of the second sql line only of the login table but it does not enter any entries in the user table

//entering the job seeker data in the user table
$sql="INSERT INTO user (name, Addr, Nation, dob, Gen, cnt, mar, mil, phone, mobile, mail, user)
VALUES
('$fn','$_POST[add]','$_POST[nat]','$dob','$_POST[gg]','$_POST[cnt]','$_POST[Mar]','$_POST[Mil]','$_POST[ph]','$_POST[mo]','$_POST[mail]','$_POST[user]')";
//entering the user and pass in the login table
$sql="INSERT INTO login (user, pass, type)
VALUES
('$_POST[user]','$_POST[pass]','$_POST[type]')";
if (!mysql_query($sql,$con))
	{
	die('Error: ' . mysql_error());
	}
	echo "<br>";
echo "<br>Thanks for registration MR. $fn ";
exit();

[spikeZ]

Thats because you are overwriting the first $sql variable with the second one!

$foo = 1;
$foo = 2;

// $foo will equal 2 

Simply use 2 mysql_query calls

//entering the job seeker data IN the user table
$sql="INSERT INTO user (name, Addr, Nation, dob, Gen, cnt, mar, mil, phone, mobile, mail, user)
VALUES
('$fn','$_POST[add]','$_POST[nat]','$dob','$_POST[gg]','$_POST[cnt]','$_POST[Mar]','$_POST[Mil]','$_POST[ph]','$_POST[mo]','$_POST[mail]','$_POST[user]')";
//entering the user AND pass IN the login table
$sql2="INSERT INTO login (user, pass, type)
VALUES
('$_POST[user]','$_POST[pass]','$_POST[type]')";
if (!mysql_query($sql,$con))
    {
    die('Error: ' . mysql_error());
    }
if (!mysql_query($sql2,$con))
    {
    die('Error: ' . mysql_error());
    }
    echo "<br>";
echo "<br>Thanks for registration MR. $fn ";
exit(); 

[kleineme]

you only have a mysql_query() for the second $sql and not for the first one

[einSTein]

thanx man its workin