This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

Error in SQL syntax

Old posts that have not been replied to for several years.
Locked
a
almighty
Voice
Posts: 30
Joined: Tue Jan 07, 2003 5:34 pm
Contact:

Error in SQL syntax

Post by almighty »

[22:25] Tcl error [inv_1]: Error 1064 (You have an error in your SQL syntax near 'log = Almighty has successfully logged in using Almighty as a username' at line 1)

the code is here:
http://www.pastebin.com/147923

Obviously its to do with
sql2 "INSERT INTO logs SET time = '$now' log = $nick has successfully logged in using $user as a username"

Whats wrong with that code?
the update query works fine.
http://www.big-bubba.co.uk
Big Brother Clone for the South West
User avatar
Papillon
Owner
Posts: 724
Joined: Fri Feb 15, 2002 8:00 pm
Location: *.no

Post by Papillon »

that link is not working... but you could try using

Code: Select all

sql2 "INSERT INTO logs SET time = '$now' log = '$nick has successfully logged in using $user as a username'" 
Elen sila lúmenn' omentielvo
Locked