PDA

View Full Version : MySQL error


Smoothie
06-30-2002, 08:25 PM
here's the error:
Invalid SQL:
SELECT signature
FROM user
WHERE userid=
LIMIT 1

mysql error: You have an error in your SQL syntax near 'LIMIT 1
' at line 5

mysql error number: 1064
Here's the code:
$userinfo=$DB_site->query_first("
SELECT signature
FROM user
WHERE userid=$bbuserid
LIMIT 1
");It's only happening to one user.

GSHelpBoy
06-30-2002, 11:42 PM
Perhaps the user name is a reserved SQL term.

Smoothie
06-30-2002, 11:46 PM
The wierd part is I as an admin can log into this persons account, and access their user cp without any problems, or errors.

Smoothie
06-30-2002, 11:47 PM
FireFly....help!

Admin
07-01-2002, 06:33 AM
Use $bbuserinfo[userid] instead of $bbuserid.

Smoothie
07-01-2002, 07:20 AM
Mucho thanks! :)