[RESOLVED] Editing my website database using phpmyadmin
Results 1 to 3 of 3

Thread: [RESOLVED] Editing my website database using phpmyadmin

  1. #1
    Join Date
    Apr 2001
    Location
    England
    Posts
    449

    Resolved [RESOLVED] Editing my website database using phpmyadmin

    I had a website built for me that contains an sql database (123oldies.co.uk). I want to make one simple change, which is, on the 'shop' page, to change the product descripton 'jewel case' to 'cd+jewel case'.
    I'm hoping this can be done on control panel in phpmyadmin, but I've looked all around and I can't find this field to edit it.
    I have found that each product line in the stock database has a variable 'cdo' which is set to 0 or 1 and this defines what is displayed.
    As you can see, I know virtually nothing about this, so simple words from anyone would be happily received.

  2. #2
    Join Date
    Feb 2001
    Location
    San Diego, CA, USA
    Posts
    726
    In phpmyadmin you will probably see several databases listed. One will be for product categories, another for items, etc. The names will be a bit confusing, and you may have to do a bit of guesswork to figure out what each one is for.

    Select the one for items. When it is selected, click the "Borwse" tab at the top. That will cause phpmyadmin to list all of the information contained in the database, displaying each "row" in the form of a set of "columns." One of the cloumns will be named something like "desc" or will contain that as part of its name. You may need to go to a next page to find it. At the bottom you'll find a couple of buttons with arrows on them; one with a single ">" and one with two of them ">>". The single arrow goes to the next page, the double arrow goes to the last page.

    When you find the item, click in the little pencil, which will allow you to edit the item.

    Good luck.

  3. #3
    Join Date
    Apr 2001
    Location
    England
    Posts
    449
    Thanks for your answer Bill. Since I posted this question I found the code I needed in a php file and edited it directly using notepad++. I should've come back to say this but I forgot about asking the question here.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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