phpMyAdmin help

[getyourbiglobster]

hello-

i am in the process of building a simple client information databse. i was ready to begin learning mysql when i found out that my host would not allow a remote connection to the databse.

my host has the phpMyAdmin console which will not help me learn anything, but it will set up my dbase. i have been referencing mysql.org help files --which has been pain in the *****. i am held up by the drop down boxes which let you select from a huge list of data types.

i'm just trying to do something simple (probably only 1 table for the time being)

id
==

client name
===========

phone
=====

address
=======

url
===

comment
=======


any nudge in the right direction would be greatly appreciated.

[redemption]

what did you mean by phpMyAdmin console? i honestly didn't know there was a console version...

i'm assumming you want suggestions for the datatypes of your fields so here's a very basic suggestion (!!DON'T follow my suggestion exactly... tailor it to suit your needs)

id
==
INT PRIMARY KEY

client name
===========
VARCHAR(20)

phone
=====
MEDIUMINT

address
=======
(you may actually want to separate this into many fields like suite no., street, zipcode,etc)
VARCHAR(255)

url
===
VARCHAR(50)

comment
=======
VARCHAR(255)

[getyourbiglobster]

thanks, that's what i needed. i also found this if anybody is interested.

http://www.itc.virginia.edu/desktop/...hpmyadmin.html