Hi Onyour,
A good starting point is the MySQL Manual.
Exactly what you decide to do depends on exactly what you are aiming for.
You will need to create some kind of structure for your database and tables. Do you just want products listed, are you going to give discounts for various products, are you going to have members or members details, special offers..... the list goes on.
For what you have given you could do something like the following;
Table Name - Products
Columns;
ID (Set to Auto increment (handy for referencing back to))
ProductNumber
ProductGroup (handy for choice by group)
ProductName
ProductDescription
ProductPictureReference
Have a look at this sample and you will see data drawn from one table (fixtures in this case) but only selected by the competition. Once you have looked at the page, try changing the comp=LC to comp=HCC at the end of the address and you will select games from a different competition. This is how it works.
Once you have an idea to the structure of your tables, then post back on this thread and someone can help some more.
Hope this gives a starting point.
Neil.
