hey guys im just learning php and mySQL right now so this will sound really noobish but ive been trying to setup a table in my database in phpmyadmin i clicked on the little php tag under the phpmyadmin logo and entered the following code in the window that opened:

CREATE TABLE meminfo (name VARCHAR, email VARCHAR, phone INT, adress FLOAT, comments VARCHAR);

after that it gives me this error:

#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 ' email VARCHAR, phone INT, adress FLOAT, comments VARCHAR)' at line 1

im sure its probably a small syntax error or something but im hoping more experienced eyes might help me pick it out ive looked through it several times and cant seem to find whats wrong. my server runs MySQL client version: 4.1.10

thanks for your time

Reguards,
Durendal420

For VARCHAR data type you must specify a maximum size - try something like - VARCHAR(255)

works great thanks a lot

Reguards,
Durendal420

adress FLOAT?????