Measurement Conversion

[hells1614]

I sell rubber stamps and my customers are always asking for different measurements i.e mm, cm or inches, well I have 1300 stamp designs to add 3 different sizes to each product info. I wonder if there is a way to incorporate a conversion web code that can be included into the web site?

[jballotti]

If you're entering the size in inches you multiply inches by 0.0254 to convert to millimeters. You should be able to add a field to the table where the size is stored that takes the size entry and converts it with a simple math expression. I know how to do this in Access but you'll have to get help from someone who knows more about MySQL than I do. Once you add this new field, it should automatically convert every entry in the table.