[newbe]

Is there anything wrong with this syntax? PHP: --------- $sql = "INSERT INTO USER_ACCOUNTS ('username','password','email','realname','postcod e','gender')...

Is there anything wrong with this syntax?

PHP Code:

$sql = "INSERT INTO USER_ACCOUNTS ('username','password','email','realname','postcod e','gender') VALUES('$reg_username','$reg_password','$reg_email ','$reg_realname','$reg_postcode','$reg_gender')";
$result = mysql_query($sql);
closedb();
if($result == true)
{
$_SESSION['user'] = $reg_username;
header('Location: user.php?regester');
exit;
}
else
{
$_SESSION['error'] = 'An unknown error accured, please try again.
';
header('Location: user.php?regester');
exit;
}

I keep getting 'An unknown error accured, please try again.'

Any help would be great ... I have a login script on the same page accessing the same database which works fine, so its not the connection.