adding problem

NZ_Kiwi

$result = mysql_query("insert into members (`id`,`username`,`firstname`,`lastname`,dob`,`address`,`city`,`country`,`phone,`email`,`password`,`nz_mailing`,`active`,`warriors_mailing`,`bcc_mailing`,`level`)values ('','".$_POST'username']."','$firstname','$lastname','$dob','$address','$city','$country','$phone','$email','".$_POST['password']."','$nz_mailing','$active','$warriors_mailing','$bcc_mailing','$level')")
or die("Could not insert data because ".mysql_error());

Could not insert data because You have an error in your SQL syntax near ',address,city,country,phone,email,password,nz_mailing,active,war' at line 1

Mordecai

You're missing a backtick before dob.
Also, I think you should know that it's generally considered polite to ask a question, rather than just state an error and code. All three in combination, however, provide for a very nice question.

NZ_Kiwi

Originally posted by Mordecai
You're missing a backtick before dob.
Also, I think you should know that it's generally considered polite to ask a question, rather than just state an error and code. All three in combination, however, provide for a very nice question.

Well just for you.... I get the above error when trying to add this to my sql database! i've fixed the dob but still have this same error...

there was another one.... all fixed thanks