LondonT

Sorry, please see this URL (Updated to Public) There is 99 entries to display, depending on the number entered on the website. For example: If you entered 1 in the form on the website, the 99 rows would show one set of data. If you entered 9 in the form on the website, the 99 rows would show a different set of data. In Excel,it's got the formulas ready to make the changes, when you edit the number (same as entering it into the formn on a webpage). It's this I Want to display on a site, but make it look presentable and not just a mess.

Hello, I've made a relatively simple Excel spreadsheet, that I need to display the contents of on a website. After researching, it appears this data needs to be put into a Database in order to pull from it in a way that looks acceptable (A table). Can someone outline how to convert to a MySQL database, please? I have tried doing the .csv option and it works, but unsure where to go from there. The Excel sheet can be found here: https://docs.google.com/a/imediums.co.uk/spreadsheets/d/1u_H6ywHHYkuDGo0NBUpTLnky9ACHRnTuAUQESBKmcb8/edit?usp=sharing The spreadsheets values change depending on the cost of 1 item (see the above link) RE: the website - I need to have a form (a simple box) where a user can enter a number from 1 - 99. Depending on the value entered, depends on the data returned (see above, the values change depending on the price of one item). So, how do I get the form to return the correct data, based on the excel (and ultimately converted to MySQ database) data? Many thanks!