SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Sql Insert Error
-
Dec 2, 2008, 03:34 #1
Sql Insert Error
Hi all
Having a major problem with this very simple SQL INSERT. Getting the classic error but just can't work out why I'm getting it.
Code MySQL:
Produces this error:
Code: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 'return VALUES('','274','Via','Shepton Mallet','fghgfg','45','test','t' at line 1
Errr WTF, please help
-
Dec 2, 2008, 03:38 #2
- Join Date
- Jan 2004
- Location
- Uppsala, sverige
- Posts
- 700
- Mentioned
- 2 Post(s)
- Tagged
- 1 Thread(s)
return is a reserved word in SQL. Either rename the table or enclose it in `` i.e.
Code:`return`
-
Dec 2, 2008, 03:56 #3
LOL of course it is
I knew it was something obvious like that!
thanks for your help swamp
Bookmarks