I put websites together using Xoops and OsCommerce. I need to know how to edit mysql databases using Cpanel. Please could you point me in the direction of some tutorials? There are some which show how to se up a database but not how to edit one.
For example, in a client's Oscommerce cart I have to delete all the items from the Best Seller box so he can start a new list there. I found some instructions on the web. The Best Seller box is reset like this:
You can use now phpMyAdmin and go to the product database and set products_ordered to "0".
I can find the file under the structure tab in mySql but dont know what to do next! :)
Would appreciate any leads.