a simple table

[lukeurtnowski]

I'm trying to create a REVIEW table but PHPMyAdmin throws an error (which I cant find) Is there an error here?
CREATE TABLE REVIEW(
ASP_Name VARCHAR,
ASP_City VARCHAR,
ASP_Phone VARCHAR,
Phone_Type VARCHAR,
Website VARCHAR,
Website_Rating VARCHAR,
ASP_Email VARCHAR,
ASP_Type VARCHAR,
Services_Offered VARCHAR,
Delivered VARCHAR,
On_Time VARCHAR,
Professional_Photos VARCHAR,
Current_Photos VARCHAR,
Found VARCHAR,
Booking VARCHAR,
Advertised_Length,
Actual_Length VARCHAR,
Advertised_Cost VARCHAR,
Actual_Cost VARCHAR,
Upselling VARCHAR,
Compensation VARCHAR,
Incall_Outcall VARCHAR,
ASP_Attitude VARCHAR,
Incall_Conditions VARCHAR,
Services VARCHAR,
ASP_Strong_Point VARCHAR,
ASP_Looks VARCHAR,
ASP_Attire VARCHAR,
ASP_Grooming VARCHAR,
ASP_Tatoos VARCHAR,
ASP_Piercings VARCHAR,
Review_For VARCHAR,
Session_Made VARCHAR,
See_Again VARCHAR,
Recommend VARCHAR,
Username VARCHAR,
Age VARCHAR,
Frequency VARCHAR,
Time_In_Hobby VARCHAR,
Activity TEXT,
Rating VARCHAR,
)

[goldlikesnow]

CREATE TABLE REVIEW(
ASP_Name VARCHAR,
ASP_City VARCHAR,
ASP_Phone VARCHAR,
Phone_Type VARCHAR,
Website VARCHAR,
Website_Rating VARCHAR,
ASP_Email VARCHAR,
ASP_Type VARCHAR,
Services_Offered VARCHAR,
Delivered VARCHAR,
On_Time VARCHAR,
Professional_Photos VARCHAR,
Current_Photos VARCHAR,
Found VARCHAR,
Booking VARCHAR,
Advertised_Length, <----- VARCHAR!!!
Actual_Length VARCHAR,
Advertised_Cost VARCHAR,
Actual_Cost VARCHAR,
Upselling VARCHAR,
Compensation VARCHAR,
Incall_Outcall VARCHAR,
ASP_Attitude VARCHAR,
Incall_Conditions VARCHAR,
Services VARCHAR,
ASP_Strong_Point VARCHAR,
ASP_Looks VARCHAR,
ASP_Attire VARCHAR,
ASP_Grooming VARCHAR,
ASP_Tatoos VARCHAR,
ASP_Piercings VARCHAR,
Review_For VARCHAR,
Session_Made VARCHAR,
See_Again VARCHAR,
Recommend VARCHAR,
Username VARCHAR,
Age VARCHAR,
Frequency VARCHAR,
Time_In_Hobby VARCHAR,
Activity TEXT,
Rating VARCHAR <---------
);

[lukeurtnowski]

made the correction and am still getting a wierd error (at least to me)

#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 '
ASP_City VARCHAR,
ASP_Phone VARCHAR,
Phone_Type VARCHAR,
W

Do you know what the dilio is?
Thanks...

[Houdini]

You did not give a size for any of the VARCHARs they have to have a size so I am supplying one. Also the last statement needs no comma, because there is nothing following it. Change the value to those that are suitable for the actual field.

CREATE TABLE REVIEW(
ASP_Name VARCHAR(35),
ASP_City VARCHAR(45),
ASP_Phone VARCHAR(16),
Phone_Type VARCHAR(15),
Website VARCHAR(55),
Website_Rating VARCHAR(5),
ASP_Email VARCHAR(45),
ASP_Type VARCHAR(15),
Services_Offered VARCHAR(65),
Delivered VARCHAR(35),
On_Time VARCHAR(35),
Professional_Photos VARCHAR(35),
Current_Photos VARCHAR(35),
Found VARCHAR(35),
Booking VARCHAR(35),
Advertised_Length VARCHAR(35),
Actual_Length VARCHAR(35),
Advertised_Cost VARCHAR(35),
Actual_Cost VARCHAR(35),
Upselling VARCHAR(35),
Compensation VARCHAR(35),
Incall_Outcall VARCHAR(35),
ASP_Attitude VARCHAR(35),
Incall_Conditions VARCHAR(35),
Services VARCHAR(35),
ASP_Strong_Point VARCHAR(35),
ASP_Looks VARCHAR(35),
ASP_Attire VARCHAR(35),
ASP_Grooming VARCHAR(35),
ASP_Tatoos VARCHAR(35),
ASP_Piercings VARCHAR(35),
Review_For VARCHAR(35),
Session_Made VARCHAR(35),
See_Again VARCHAR(35),
Recommend VARCHAR(35),
Username VARCHAR(35),
Age VARCHAR(35),
Frequency VARCHAR(35),
Time_In_Hobby VARCHAR(35),
Activity TEXT,
Rating VARCHAR(35)
)

[lukeurtnowski]

thanks