Updating mysql table with values in SQL Posted August 11, 2020 I am stuck with a problem. Have a shopping cart, once the client selects the products, from a SQL table (1), they are taken up by an array variable A session array variable delivers values using foreach loop. The php shows all the values sequentially But the SQL table (2) gets updated with only the last value. Understand that this will happen due to looping. So how to go about resolving this
Updating mysql table with values
in SQL
Posted
I am stuck with a problem.
Have a shopping cart, once the client selects the products, from a SQL table (1), they are taken up by an array variable
A session array variable delivers values using foreach loop.
The php shows all the values sequentially
But the SQL table (2) gets updated with only the last value.
Understand that this will happen due to looping.
So how to go about resolving this