[marsters256]

Over an hour now I'm starting to go mad...

INSERT INTO union (AutoID, first_name, organisation, post_code, email, contact, resident, parliament, alphabeta, courage, Regdate) VALUES ('', 'ben', 'bencorp', 'cty12ld', 'will@hot.com', 'address12321', '1', 'bush', '0', '4', '12')




#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 'union (AutoID, first_name, organisation, post_code, email, contact, resident, pa' at line 1

gaaaaah please help

[End User]

I think you may be running into trouble by using "UNION" for a table name.

"UNION" is a reserved word, so if you're going use it as a table name (not really a good idea) then you'll need to put backticks (`) around it.

[hon33y]

UNION is a key word. try this.

INSERT INTO [union] (AutoID, first_name, organisation, post_code, email, contact, resident, parliament, alphabeta, courage, Regdate) VALUES ('', 'ben', 'bencorp', 'cty12ld', 'will@hot.com', 'address12321', '1', 'bush', '0', '4', '12')

[Jcbones]

or this

PHP Code:

INSERT INTO `union` (AutoID, first_name, organisation, post_code, email, contact, resident, parliament, alphabeta, courage, Regdate) VALUES ('', 'ben', 'bencorp', 'cty12ld', 'will@hot.com', 'address12321', '1', 'bush', '0', '4', '12') 

[marsters256]

Omg lol I'll give that a try and get back to you.

Who knew?

well... you guys obvisously... but not me...

[marsters256]

yes it worked thankyou very much.