Insert

NZ_Kiwi

I'm either blind or mad!

this does not add but also does not give me a error. Sorry if this seems stupid to most

$q = "INSERT INTO `members` (`username`,`password`,`email`,`firstname`,`lastname`,`dob`,`address`,`city`,`country`,`phone`,`email`,`nz_mailing`,`warriors_mailing`,`bcc_mailing`) "."VALUES ('".$_POST["username"]."', "."PASSWORD('".$_POST["password"]."'), "."'".$_POST["email"]."','".$_POST["firstname"]."','".$_POST["lastname"]."','".$_POST["dob"]."','".$_POST["address"]."','".$_POST["city"]."','".$_POST["country"]."','".$_POST["phone"].",'".$_POST["email"]."','".$_POST["nz_mailing"]."','".$_POST["warriors_mailing"]."','".$_POST["bcc_mailing"]."')";

SQL

CREATE TABLE members (
id int(11) NOT NULL auto_increment,
username varchar(250) NOT NULL default '',
password varchar(250) NOT NULL default '',
firstname varchar(250) NOT NULL default '',
lastname varchar(250) NOT NULL default '',
dob date NOT NULL default '0000-00-00',
address varchar(250) NOT NULL default '',
city varchar(250) NOT NULL default '',
country varchar(250) NOT NULL default '',
phone varchar(250) NOT NULL default '',
email varchar(250) NOT NULL default '',
nz_mailing int(11) default '0',
active int(11) default '0',
warriors_mailing int(11) default '0',
bcc_mailing int(11) default '0',
level int(10) default '1',
KEY id (id)
) TYPE=MyISAM AUTO_INCREMENT=31 ;

intenz

Try...

$q = "INSERT INTO `members`  (`username`,`password`,`email`,`firstname`,`lastna
me`,`dob`,`address`,`city`,`country`,`phone`,`emai
l`,`nz_mailing`,`warriors_mailing`,`bcc_mailing`) "."VALUES ('".$_POST["username"]."', "."PASSWORD('".$_POST["password"]."'), "."'".$_POST["email"]."','".$_POST["firstname"]."','".$_POST["lastname"]."','".$_POST["dob"]."','".$_POST["address"]."','".$_POST["city"]."','".$_POST["country"]."','".$_POST["phone"].",'".$_POST["email"]."','".$_POST["nz_mailing"]."','".$_POST["warriors_mailing"]."','".$_POST["bcc_mailing"]."')";

mysql_query( $q ) or die( mysql_error() );

NZ_Kiwi

Originally posted by intenz
Try...

$q = "INSERT INTO `members`  (`username`,`password`,`email`,`firstname`,`lastna
me`,`dob`,`address`,`city`,`country`,`phone`,`emai
l`,`nz_mailing`,`warriors_mailing`,`bcc_mailing`) "."VALUES ('".$_POST["username"]."', "."PASSWORD('".$_POST["password"]."'), "."'".$_POST["email"]."','".$_POST["firstname"]."','".$_POST["lastname"]."','".$_POST["dob"]."','".$_POST["address"]."','".$_POST["city"]."','".$_POST["country"]."','".$_POST["phone"].",'".$_POST["email"]."','".$_POST["nz_mailing"]."','".$_POST["warriors_mailing"]."','".$_POST["bcc_mailing"]."')";

mysql_query( $q ) or die( mysql_error() );

[/B]

thanks for trying but still nothing!

Yegg

Try to escape all values with mysql_escape_string - what you are sending to insert query.