{ $id = $r['id']; $email = $r['email']; $clan = ''; $username = $r['username']; $password = ''; $oldpassword = $r['password']; $avatar = ''; $logins = $r['visits']; echo ':'.$email.'| '.$username.'| '.$oldpassword.'| '.$logins.'| '.$register_date.'| '.$last_login.'<br />'; $dodaj_nowa = mysql_query('INSERT INTO users (id, email, username, password, oldpassword, avatar, logins, register_date, last_login) VALUES ('.$id.', '.$email.', '.$clan.', '.$username.', '.$password.', '.$oldpassword.', '.$avatar.', '.$logins.', '.$register_date.', '.$last_login.')', Nowa()); NowaClose(); }
CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `email` varchar(254) NOT NULL, `clan` varchar(254) NOT NULL, `username` varchar(32) NOT NULL DEFAULT '', `password` varchar(64) NOT NULL, `oldpassword` varchar(64) NOT NULL, `avatar` varchar(255) NOT NULL, `logins` int(10) UNSIGNED NOT NULL DEFAULT '0', `register_date` datetime NOT NULL, `last_login` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniq_email` (`email`), UNIQUE KEY `uniq_username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Wpisy pobiera prawidłowo, ale nie dodaje nowych do bazy danych, co jest nie tak?