MySQL query

[BigEmmaFanz]

I have downloaded a "users online" script and I need to create a table on a database manually.

I'm already in the phpmyadmin and have already chosen the database that I want to use. But I come across this bit of instructions in the manual of the script that I've downloaded.

Thing is, I'm new to this so I have no idea what the code means or how I'm supposed to do what they want.

The create a table part of phpmyadmin has a Name field and Fields field. Please, any help would be appreciated.

CREATE TABLE `users_online` (
`visitor` VARCHAR( 15 ) NOT NULL ,
`lastvisit` INT( 14 ) NOT NULL
);

 

[bigguy]

Would you not put 'users_online' in the name field and the rest in the fields field. I dont know much about it so I could very well be wrong, but thats my guess.

 

[BigEmmaFanz]

That's what I was thinking too... but that was till I read the visitor and the varchar thing and the numbers... I was like... whaddahell?

 

[BigEmmaFanz]

w00t... I did it...

I clicked on "SQL" at the top menu and just pasted that bit of code into the text area...

and it did the job for me... ^_^

Please close this thread... Thanks!

 

[bigguy]

I`ll leave this open it might help some one else, maybe.