| Author |
Message |
Desbrina
Jadeite
Joined: 11 Jun 2005
Posts: 2972
Location: Earth
|
 Posted: Sat Jan 26, 2008 1:37 pm Post subject: sql statement not working |
 |
|
Hopefully a new set of eyes at this sql might find the error. I've been looking for 30ish minutes
| Quote: | SQL query:
SQL Statement : UPDATE `memberlist` SET `name` = 'Desbrina',
`collecting` = 'jupiter',
`email` = 'desbrina1@yahoo.co.uk',
`birthday` = '30 November',
`hiatus` = '0' WHERE `ID` =15 LIMIT 1
MySQL said: Documentation
#1064 - 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 'SQL Statement: UPDATE `memberlist` SET `name` = 'Desbrina', `collecting` = 'jupi' at line 1 |
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG |
|
| Back to top |
|
| |
Desbrina
Jadeite
Joined: 11 Jun 2005
Posts: 2972
Location: Earth
|
|
| Back to top |
|
| |
krt
...
Joined: 11 Jan 2005
Posts: 4681
Location: Down Under
|
| Posted: Sat Jan 26, 2008 10:32 pm Post subject: |
|
|
| I'd get your email removed from that post, it's an open target for email harvesters at the moment. |
|
| Back to top |
|
| |
Ayana
Master Poster
Joined: 04 Nov 2006
Posts: 205
|
|
| Back to top |
|
| |
krt
...
Joined: 11 Jan 2005
Posts: 4681
Location: Down Under
|
| Posted: Thu Jan 31, 2008 6:34 pm Post subject: |
|
|
| Ayana wrote: | | well , thats the most interesting SQL statement error i've seen |
Don't worry, it is probably just for testing, not something hard coded in a script as you probably suspected. |
|
| Back to top |
|
| |
Desbrina
Jadeite
Joined: 11 Jun 2005
Posts: 2972
Location: Earth
|
| Posted: Fri Feb 01, 2008 3:22 am Post subject: |
|
|
nope, that's not what's in the script. The actual code uses variables instead of information. That information in the statement was from where i printed it to see what's actually happening and what information is trying to be updated and to what since there's 2 statements depending on if they entered a new password
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG |
|
| Back to top |
|
| |
|
|
|
Forum FAQs 
Knowledge Base 
Memberlist 
Usergroups 
Hosting
Register
Donate 
Profile 
Log in 
