SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: phpMyAdmin help

  1. #1
    SitePoint Enthusiast
    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.

  2. #2
    SitePoint Wizard silver trophy redemption's Avatar
    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)

  3. #3
    SitePoint Enthusiast
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •