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