I'm trying to update a mySQL database from the info contained in an html form with checkboxes using PHP. Here's an example of what I'm trying to do:
Stock number: 555 is available in red, white, blue, and green. My form will have a text box for the stock number and checkboxes for the colors. My database should show 4 rows with 2 columns: stock number 555 (in column 1) and red (in column 2); then 555 and white (in the next row); then 555 and blue; etc. The stock number should repeat in each row until all of the available colors are shown (only one color will show in the column in each row). Is this possible? How would I do this? I'm fairly new to PHP so please include as much detail as possible. If you can recommend any courses/books to learn PHP more indepth, it would be greatly appreciated.