mysql error

[ogri]

1. create a database-table:

CREATE TABLE useronline (

time int(15) NOT NULL,

ip varchar(15) NOT NULL,

file varchar(50) NOT NULL,

PRIMARY KEY (time),

KEY ip (ip),

KEY file (file) );

these are the instructions to create the tables.

ive atatched a jpg of what ive entered and here is the error message im receiving when trying to save the tables.

#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 '(time), `key ip` TEXT(ip), `key file` TEXT(file))' at line 1

any help appreciated

[metal_dragen Veteran]

You're using phpMyAdmin. Just click the SQL tab at the top and paste that code into the box and hit the button.

[ogri]

spot on m8.

your a star worked first time.

only problem now is the app i wanted to use isnt doing what it aught too.