SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: phpMyAdmin help
-
Jan 15, 2002, 01:59 #1
- Join Date
- Feb 2001
- Posts
- 58
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
phpMyAdmin help
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.
-
Jan 15, 2002, 02:17 #2
- Join Date
- Sep 2001
- Location
- Singapore
- Posts
- 5,269
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Re: phpMyAdmin help
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)
-
Jan 15, 2002, 19:15 #3
- Join Date
- Feb 2001
- Posts
- 58
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
thanks, that's what i needed. i also found this if anybody is interested.
http://www.itc.virginia.edu/desktop/...hpmyadmin.html
Bookmarks