Argh...I thought it was the field 'Dec' causing a problem again...but I renamed it to 'Dece' and I'm still getting problems. The command is;
CREATE TABLE Users(Person_Name TEXT(200) NULL ,Person_Email TEXT(200) NULL ,PayPal_Email TEXT(200) NULL ,Domain_Name TEXT(200) NULL ,Package TEXT(200) NULL ,This_Month_Paid TEXT(200) NULL ,Jan TEXT(15) NULL ,Feb TEXT(15) NULL ,Mar TEXT(15) NULL ,Apr TEXT(15) NULL ,May TEXT(15) NULL ,June TEXT(15) NULL ,July TEXT(15) NULL ,Aug TEXT(15) NULL ,Sept TEXT(15) NULL ,Oct TEXT(15) NULL ,Nov TEXT(15) NULL ,Dece TEXT(15) NULL ,Extra Bandwidth TEXT(15) NULL , UNIQUE (Domain_Name))
and the error reported is;
MySQL said: You have an error in your SQL syntax near '(200) NULL ,Person_Email TEXT(200) NULL ,PayPal_Email TEXT(200) NULL ,Domain_' at line 1.
Can anyone see a problem with that query? Its probably something right under my nose...but I just can't see it
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
CREATE TABLE Users(Person_Name TEXT(200) NULL ,Person_Email TEXT(200) NULL ,PayPal_Email TEXT(200) NULL ,Domain_Name TEXT(200) NULL ,Package TEXT(200) NULL ,This_Month_Paid TEXT(200) NULL ,Jan TEXT(15) NULL ,Feb TEXT(15) NULL ,Mar TEXT(15) NULL ,Apr TEXT(15) NULL ,May TEXT(15) NULL ,June TEXT(15) NULL ,July TEXT(15) NULL ,Aug TEXT(15) NULL ,Sept TEXT(15) NULL ,Oct TEXT(15) NULL ,Nov TEXT(15) NULL ,Dece TEXT(15) NULL ,Extra Bandwidth TEXT(15) NULL , UNIQUE (Domain_Name))
and the error reported is;
MySQL said: You have an error in your SQL syntax near '(200) NULL ,Person_Email TEXT(200) NULL ,PayPal_Email TEXT(200) NULL ,Domain_' at line 1.
Can anyone see a problem with that query? Its probably something right under my nose...but I just can't see it
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!