Getting mysql_error 0

[Gigga]

Why do I fall into the "Problem" echo and mysql_error is 0. I am going crazy. It was working before and I dont know what I did.
Thanks!

======================
$cryptps = crypt($_POST['password']);
$sql=("INSERT INTO members (username, first_name, last_name, email_addr, location, carpool, join_date, profession, marital_status, send_event, send_comment,

password)
VALUES ('$_POST[username]', '$_POST[first_name]', '$_POST[last_name]','$_POST[email_addr]','$_POST[location]', '$_POST[carpool]', curdate(), '$_POST

[profession]', '$_POST[status]', '$_POST[emailevt]','$_POST[emailcmt]','$cryptps')");
$result = mysql_query($sql,$con);
if(!$result)
{
if (mysql_errno() == 1062)
{
echo '<br></br>';
echo "Username already exists. Please go back and try again.";
}
else
{
mysql_close($con);
echo '<br></br>';
echo "Problem* " ;
die('Error: ' . mysql_error() );
}
}
else
{

echo '<br></br>';
echo "Congratulations! You are registered."

[macek]

Could you send us: echo 'XXX ' . $sql . ' XXX'; ?

[Gigga]

Here it is:

xxx INSERT INTO members (username, first_name, last_name, email_addr, location, carpool, join_date, profession, marital_status, send_event, send_comment, password) VALUES ('Lucy', 'Lucy', 'Wong','lucywong@gmail.com','United States', 'n', curdate(), 'Programmer', 'single', 'y','y','$1$Dj0.QZ4.$N6/ivKCDrxyFdV4NlCE.00') xxx

Thanks!

[Gigga]

Never mind. I figured it out. It was my $con!