Error in MySQL
Ik ben bezig met een registratiescript en heb, nadat ik in de rest van het script geen errors krijg, een error in de MySQL:
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 '(id, username, usernameclean, email, password_md5, ip, date) INTO users ' at line 1
De SQL code is:
Code (php)
1
2
3
4
5
2
3
4
5
$sql_reg = "
INSERT (id, username, usernameclean, email, password_md5, ip, date)
INTO users
VALUES (NULL, '" . $username . "', '" . $usernameclean . "', '" . $email . "', '" . $password . "', '" . $ip . "', CURRENT_TIMESTAMP, '1');
";
INSERT (id, username, usernameclean, email, password_md5, ip, date)
INTO users
VALUES (NULL, '" . $username . "', '" . $usernameclean . "', '" . $email . "', '" . $password . "', '" . $ip . "', CURRENT_TIMESTAMP, '1');
";
Weet iemand waar het aan ligt?
Alvast bedankt, Kees.
