Jump to content


Photo

Annoying Error.


  • Please log in to reply
2 replies to this topic

#1 SocialCloud

SocialCloud

    Advanced Member

  • Members
  • PipPipPip
  • 620 posts

Posted 06 December 2012 - 08:39 PM

I've been trying to debug this code for an hour now. :facewall:

Returns the following error:
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 'group,email,verified,redirect) VALUES ( 'Bob', 'Bobly', 'Admin', '6efe0def62d76' at line 1

<?php
$sql = "INSERT INTO `users` (firstname,lastname,username,password,group,email,verified,redirect) VALUES (
'$first',
'$last',
'$user',
'$pass',
'Member',
'$email',
'$verified',
'$redirect')";
?>

Anyone see what's wrong?

#2 Pikachu2000

Pikachu2000

    I hate everything.

  • Staff Alumni
  • 11,378 posts
  • LocationFuture Independent Republic of Texas
  • Age:106

Posted 06 December 2012 - 08:40 PM

http://dev.mysql.com...rved-words.html
"Java" is to "Javascript" about the same as "fun" is to "funeral".

Why $_SERVER['PHP_SELF'] is bad. || Why ORDER BY RAND() is bad || Every problem can be solved with rm -rf *

Random Quote: "

#3 SocialCloud

SocialCloud

    Advanced Member

  • Members
  • PipPipPip
  • 620 posts

Posted 06 December 2012 - 08:45 PM

Ah...yes...Err tyvm. problem solved lol :sweat:




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com