· 8 years ago · Apr 06, 2018, 06:20 AM
1$result2 = mysql_query ("INSERT INTO users (login,password)
2VALUES('$login','$password')");
3$result2 = mysql_query ("INSERT INTO tasters SET id=LAST_INSERT_ID()");
4
5CREATE TABLE IF NOT EXISTS `users` (
6`id` int(11) NOT NULL AUTO_INCREMENT,
7`login` varchar(18) NOT NULL,
8`password` varchar(18) NOT NULL,
9`status` int(11) NOT NULL DEFAULT '3',
10PRIMARY KEY (`id`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
12
13CREATE TABLE IF NOT EXISTS `tasters` (
14`id` int(11) NOT NULL,
15`name` varchar(32) NOT NULL,
16`surname` varchar(32) NOT NULL,
17`patronymic` varchar(32) NOT NULL,
18`sex` int(11) NOT NULL,
19`birth` date NOT NULL,
20`salary` int(11) NOT NULL,
21`marital_status` int(11) NOT NULL,
22`children` int(11) NOT NULL,
23PRIMARY KEY (`id`)
24) ENGINE=MyISAM DEFAULT CHARSET=utf8;