Scratch
archived forums
This is a read-only archive of the old Scratch 1.x Forums. Try searching the current Scratch discussion forums.
#1 2011-02-27 14:20:05
- TheSuccessor
- Scratcher
- Registered: 2010-04-23
- Posts: 1000+
SQL query problem
According to the database which I am sending the query to, there is a sytax error in this:
UPDATE users SET scratch='TheSuccessor',mod='xCubed, PowerPack' WHERE id=5
Can anybody spot the problem and let me know?
Thanks in advance 
/* No comment */
Offline
#2 2011-02-28 11:44:26
- TheSuccessor
- Scratcher
- Registered: 2010-04-23
- Posts: 1000+
Re: SQL query problem
Bump
/* No comment */
Offline
#4 2011-03-01 11:10:53
- TheSuccessor
- Scratcher
- Registered: 2010-04-23
- Posts: 1000+
Re: SQL query problem
No luck. 
Thanks for trying though.
/* No comment */
Offline
#5 2011-03-01 15:52:27
- TheSuccessor
- Scratcher
- Registered: 2010-04-23
- Posts: 1000+
Re: SQL query problem
Bump...
/* No comment */
Offline
#6 2011-03-01 18:14:05
Re: SQL query problem
The problem is the comma before "mod=". Remove it and it should be fine.
A good web site to get questions like this answered is:
http://stackoverflow.com
Last edited by BoltBait (2011-03-01 18:14:56)
Animated sigs must be banned!
Offline
#7 2011-03-01 18:58:43
- thebuilderdd
- Scratcher
- Registered: 2008-01-26
- Posts: 1000+
Re: SQL query problem
I don't know SQL. I use it on my forums and wordpress though.
Offline