SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    xyz
    Posts
    158
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am using phpmyadmin to create a database, since my provider won't let me use telnet or my own MySQL client. I can't figure out how to do the ALTER commands as shown in Part 5 of the tutorial. After I have made a table, it seems I can only change/add rows, but not the columns of the table...

    Please help. I'm stuck and I want to continue this exciting tutorial

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I confess I've never used PHPMyAdmin for any length of time, so I couldn't tell you for sure whether there is no way to alter an existing table's structure or there is such a feature that is just well hidden.

    The alternative to using PHPMyAdmin is to write a simple SQL-processing page for yourself. The complete code for such a page is provided in "Professional PHP Programming" from Wrox Press, and is freely downloadable here. Download and unzip the file. Edit query.php and mysql_test.php (both in the "BOOKS\2963 Pro PHP\Full Code\Chapter 12" directory) to assign the appropriate values to $user and $password, then copy these two files to your Web server in a password-protected directory (as you did for PHPMyAdmin). Load query.php and type any SQL query you want, just like on the MySQL command line!


    ------------------
    -Kevin Yank.
    http://www.SitePoint.com/
    Helping Small Business Grow Online!


    [This message has been edited by kyank (edited June 22, 2000).]

  3. #3
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Make sure you have got the newest version of the scripts because there were bugs in some versions that stopped LATER commands working sometimes.

    Also check with your ISP that you have got permission to ALTER tables etc. They may not have given you this permission (Although I can't see why they wouldn't let you alter your own database).

    If you still have no look then post the error message you get from phpMyAdmin and I will have a look.

    I use phpMyAdmin on all the sites I work on and maintain.

    ------------------
    Karl Austin
    KDA Web Services
    "Everyone has a photographic memory. Some just don't have film."

  4. #4
    SitePoint Evangelist
    Join Date
    May 2000
    Location
    Canada
    Posts
    533
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    we have phpmyadmin incorporated in our control panel

    anyhow, click on your database, and you'll get a list of tables, with options like "insert" , "browser" .. there is also a "properties" .. click on that for the table you need to ALTER .. .then you have options to add fields and change fields.. that is what you are specifically looking for..

    hope that helps
    ---------------------
    Kryogen WebHosting - when you want a REAL host

  5. #5
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    xyz
    Posts
    158
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It turned out the problem had two sides:
    1) I couldn't find the "add new field" feature of phpmyadmin
    2) My provider had permission for ALTER off.

    Thanks for helping to solve the problem!


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
  •