I have an Array that comes from a Post form that is auto generated by a php script I need to add these into a mysql database but I can't figure out how to loop through the info and store it in a database.
I want a page named process.php that takes the array data and in the end updates the database with a MySQL statement like the one below. It has to use variables so I don't have to hard code everything.
UPDATE `URL` SET `Column`=$Column# WHERE `Group Category` LIKE '$colGroupCat#'
I probably will add more columns.
[colGroupCat1] => Bathroom
[Column1] => 3
[colGroupCat2] => Carpet
[Column2] => 3
[colGroupCat3] => Organic Pesticides
[Column3] => 3
[colGroupCat4] => Organizing
[Column4] => 3