I read a tutorial somewhere on the internet which showed a user how to create a simple mysql database enter information from a html form and then retrieve the information using another HTML form.
Does anybody know where this tutorial is or would you be willing to provide some information on how i could achieve this.
I want to create a database that will contain 7 manufacturers names and 7 code boxes, the codes themself refer to a color code for a cotton color for instance.
Manufacturer 1 has a white color floss listed on its website as color code 2
However
Manufacturer 2 has a white color floss listed on its website as color code 12
In the same instance
Manufacturer 3 has a white color floss listed on its website as color code White
therefore i want to create a database that will allow me to enter all the manuaturers and there codes and then create a simple html form that will output the results in order to compare all the diferenet color codes for all the diferenet manufacturer.
For instance if a user comes along to my site and wants to find an alternative manufacturer of a white color floss he or she will enter the code of the color they have depending on there manufacturer i then want the results to display the results of all the other available codes from other manufacturers.
I know this is probably easy to do but i just dont know where to start how to go about setting out the database and what information to include on it.