Email validating help

[carlg]

ok i am instaling Email validating but i am have it a prblem it sends the email to me with the code in to i click it and i get

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '', unix_timestamp(), '', -1, '',' at line 1
Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( 'testing', md5(''), 1, , 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '', unix_timestamp(), '', -1, '', '')

 

here is the code that i am useing

 

$db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '{$username}',  md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP')");
$i=$db->insert_id();
$db->query("INSERT INTO userstats VALUES($i, 10, 10, 10, 10, 10)");
$db->query("INSERT INTO pdetails VALUES($i, 'N/A', 'N/A', 0, 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'OFF'") or die(mysql_error());

 

any ides how to fix this?

[ignite]

Re: Email validating help

Just wondering but why are you inserting a new user ?

[AlabamaHit]

Re: Email validating help

VALUES( '{$username}', md5('{$_POST['password']}'), 1,

You left out the login name you jumped from username to password

[AlabamaHit]

Re: Email validating help

change taht is all messed up...make sure you insert the values in order....its wayyyy off