[HELP: DEADLINE TODAY, Syntax Error]

That worked, Ididnt eve notice I had the byte values after the text, see what happens when you work too much THank, that makes the site work all correctly know

[HELP: DEADLINE TODAY, Syntax Error]

The mySQL query is as follows:

 

 

CREATE TABLE listings(



`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

PROPERTY_NM CHAR( 15 ) ,

BEDROOM_NB TINYTEXT( 1 ) ,

MINIMUMRENT_AT TINYINT( 4 ) ,

MAXIMUMRENT_AT TINYINT( 4 ) ,

MINIMUMBATHROOM_NB CHAR( 1 ) ,

MAXIMUMBATHROOM_NB CHAR( 1 ) ,

MINIMUMSQUAREFEET_NB TINYINT( 4 ) ,

MAXIMUMSQUAREFEET_NB TINYINT( 4 ) ,

URL_NM CHAR( 85 ) ,

IMAGEURL_NM TINYTEXT( 54 ) ,

COMMENT_TX TINYTEXT( 983 ) ,

CONTACTCITY_NM TINYTEXT( 7 ) ,

CONTACTSTATE_CD TINYTEXT( 2 ) ,

CONTACTZIP_CD SMALLINT( 5 ) ,

COVEREDPARKING_ID TINYTEXT( 1 ) ,

GARAGEDIRECTACCESS_ID CHAR( 1 ) ,

GARAGEDETACHED_ID CHAR( 1 ) ,

ASSIGNEDPARKING_ID CHAR( 1 ) ,

GATEDCOMMUNITY_ID CHAR( 1 ) ,

ONSITEPATROL_ID CHAR( 1 ) ,

PLAYGROUND_ID CHAR( 1 ) ,

POOL_ID CHAR( 1 ) ,

JACUZZI_ID CHAR( 1 ) ,

FITNESSCENTER_ID CHAR( 1 ) ,

TENNISCOURT_ID CHAR( 1 ) ,

RACQUETBALLCOURT_ID CHAR( 1 ) ,

CLUBHOUSE_ID CHAR( 1 ) ,

BUSINESSCENTER_ID CHAR( 1 ) ,

LAUNDRYFACILITY_ID CHAR( 1 ) ,

ELEVATOR_ID CHAR( 1 ) ,

STORAGE_ID CHAR( 1 ) ,

WHEELCHAIRACCESS_ID CHAR( 1 ) ,

DOGSALLOWED_ID CHAR( 1 ) ,

CATSALLOWED_ID CHAR( 1 ) ,

FURNISHED_ID CHAR( 1 ) ,

BALCONY_ID CHAR( 1 ) ,

YARD_ID CHAR( 1 ) ,

WASHERDRYER_ID CHAR( 1 ) ,

WASHERDRYERHOOKUP_ID CHAR( 1 ) ,

INTRUSIONALARM_ID CHAR( 1 ) ,

AIRCONDITIONING_ID CHAR( 1 ) ,

CEILINGFAN_ID CHAR( 1 ) ,

REFRIGERATOR_ID CHAR( 1 ) ,

DISHWASHER_ID CHAR( 1 ) ,

GARBAGEDISPOSAL_ID CHAR( 1 ) ,

MICROWAVE_ID CHAR( 1 ) ,

HARDWOODFLOOR_ID CHAR( 1 ) ,

CARPETING_ID CHAR( 1 ) ,

FIREPLACE_ID CHAR( 1 ) ,

WALKINCLOSET_ID CHAR( 1 ) ,

VAULTEDCEILING_ID CHAR( 1 ) ,

HIGHSPEEDINTERNET_ID CHAR( 1 ) ,

CABLEREADY_ID CHAR( 1 ) 

) 



MySQL said: 





You have an error in your SQL syntax near \'(1), MINIMUMRENT_AT TINYINT(4), MAXIMUMRENT_AT TINYINT(4), MINIMUMBATHROOM_NB CH\' at line 1

 

I am not sure what the error is, it is the same if I add single quotes around the field names or not....I don\'t know what I am not seeing...

 

Thanks