PHPmyadmin to create a many-to-many Mysql database

Discussion in 'Database' started by harshamutu, Sep 11, 2012.

  1. harshamutu

    harshamutu New Member

    Joined:
    Sep 11, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi! Everyone, I am quite new to PHP and Mysql, but capable of creating a simple database, upload it and make a PHP query to get a result displayed on a webpage using Phpmyadmin. Because of the challenge that I am going to detail below I read a lot on M-to-M databases and creating mapping tables etc. But I am still not sure where to start my assignment yet. My problem is:

    How to create a MySQL database using Phpmyadmin, for a Many-to-Many relationship. There are many suppliers and a limited number of products. One supplier may have more than one product to offer and one product can be available with several suppliers? (I guess Supplier, Products and the Mapping should have different tables in this database.)

    I shall appreciate very much if some one can advise me on these tasks and/or let me have URLs of tutorials that address these specific issues.

    Thanking you in advance Harsha Mutucumarana
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice