Can anyone help me with this
have PHP Traid working fine on local machine
phpadmin runing ok no problem on local machine...but
when I try to upload it to the server using the upload
function on the servers PHPadmin I keep getting this
error...driving me crazy...been tring for hours...
TonyQ-netstarhost.con


SQL-query:

CREATE TABLE datafare (
CLIENT char(255) NOT NULL,
AUDITOR char(255) NOT NULL,
AGENT char(255) NOT NULL,
JDATE char(255) NOT NULL,
PASSENGER char(255) NOT NULL,
COSTCENTER char(255) NOT NULL,
COSTBEFORE double DEFAULT '0' NOT NULL,
COSTAFTER double DEFAULT '0' NOT NULL,
CHANGECODE char(255) NOT NULL,
CONVERSION char(255) NOT NULL,
COMMENT char(255) NOT NULL,
PNRNO char(255) NOT NULL,
DEPARTURE char(255) NOT NULL,
DESTINATIO char(255) NOT NULL,
SALESMAN char(255) NOT NULL,
TRAVDATE char(255) NOT NULL,
ALB char(255) NOT NULL,
ALA char(255) NOT NULL,
TICKDATE char(255) NOT NULL,
GROUP char(255) NOT NULL,
CLASS char(255) NOT NULL,
DISCOUNT double DEFAULT '0' NOT NULL,
LEG char(255) NOT NULL,
COACH double DEFAULT '0' NOT NULL,
AUDTIME char(255) NOT NULL,
MILAGE double DEFAULT '0' NOT NULL,
BOOKDATE char(255) NOT NULL,
SUBDIV char(255) NOT NULL,
APCODE char(255) NOT NULL,
REGION1 char(255) NOT NULL,
COUNTRY1 char(255) NOT NULL,
STATE1 char(255) NOT NULL,
CITY1 char(255) NOT NULL,
REGION2 char(255) NOT NULL,
COUNTRY2 char(255) NOT NULL,
STATE2 char(255) NOT NULL,
CITY2 char(255) NOT NULL,
ID char(255) NOT NULL,
ORGAN char(255) NOT NULL,
OFFICE char(255) NOT NULL,
BUDGET char(255) NOT NULL,
CURRENCY char(255) NOT NULL,
PCC char(255) NOT NULL,
FA_YN char(255) NOT NULL
)
MySQL said: You have an error in your SQL syntax near
'GROUP char(255) NOT NULL, CLASS char(255) NOT NULL,
DISCOUNT double DEFA' at line 21
Back

GROUP BY is a clause used in conjunction with SELECT statement and summarizes SQL queries instead of producing rows of results. ie it groups similar results.

mySQL is expecting a ' BY' suffix so it errors there, change it to something else like 'GROUP2' and it should work.

Example of Group Query: Select office, min(quota), max(quota) from salrereps group by office

Thanks I works