I've just started reading up on using mysql and php so am working through a few tutorials with little knowledge at the moment. I have also ordered simply sql to help along the way.
My question is, how would I create a usable table like the one below in sql? This is just a small excerpt as the width extends to 'L' and thickness to 6.0cm.
a b c d e
1.0cm 3.0 3.1 3.2 3.3 3.4
2.0cm 3.6 3.7 3.8 3.9 4.0
A-E is the tubing diameter.
1cm-2cm is the thickness of the tubing.
Other values are the weight of the tubing.
The tubing will also come in different metals (i.e brass, copper).
I would like to create a page where a user would be able to select the tube material, diameter and thickness from drop down lists. The weight is then multiplied by a price I have which is then displayed on the page for the end user. So I'm guessing there would be four variables which change.
I'm uncertain (from what I've read so far) as to the best layout to use for each table, or if I could combine all the information into one large table.
Help would be much appreciated at this early stage. Thanks.