Mein alzeit am meist gehasster PHP Fehler ist wieder aufgetreten -.-
(Die dummen Mysql_query Syntax was nur ein scheiß schreibt)
Der query :
Die DB:
der Fehler
(Die dummen Mysql_query Syntax was nur ein scheiß schreibt)
Der query :
PHP Code:
INSERT INTO
`crduser`.`costumer`
SET
`first_name` = '$this->first_name',
`last_name` = '$this->last_name',
`email` = '$this->email',
`zip_code` = '$this->zip_code',
`city` = '$this->city',
`street` = '$this->street'
`phone` = '$this->phone',
`birthday` = '$this->birthday',
`password` = PASSWORD('$this->password'),
`secure_answer` = '$this->secure_answer',
`secure_question` = '$this->secure_question',
`costumer_number` = '$this->costumer_number',
`activate_code` = '$this->activate_code',
`user_status` = '$this->user_status',
`user_admin` = '$this->user_admin'
PHP Code:
CREATE TABLE `costumer` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(22) NOT NULL,
`last_name` varchar(22) NOT NULL,
`zip_code` int(12) NOT NULL,
`city` varchar(22) NOT NULL,
`street` varchar(42) NOT NULL,
`email` varchar(42) NOT NULL,
`birthday` varchar(42) NOT NULL,
`password` varchar(42) NOT NULL,
`secure_question` int(10) NOT NULL,
`secure_answer` varchar(42) NOT NULL,
`user_status` int(10) NOT NULL,
`user_admin` int(10) NOT NULL,
`activate_code` varchar(60) NOT NULL,
`voucher` int(10) NOT NULL,
`costumer_number` varchar(60) NOT NULL,
`phone` int(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
PHP Code:
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 '`phone` = '0****', ` birthday` = '17/**/****', `pass' at line 10