Mysql, Dynamic Forms to Array

andymate

Hi,

I have been working on a small project where information from a database is displayed (while command and mysql query), one of these is a form which can be changed to different value (in this case its for quantity).

Basically what i want it to do is put all the new quantities and also the id's into an array (done that)

then after its done, validate them with the database values and if they need to be updated they can be.

So far i have got some of the values out with

foreach ($_POST['item_id'] as $key=>$value)
{
echo $key. " " . $value . "<BR> \n";
}
That gets me something like this

0 1
1 9
2 5
3 4

first row is count and second row is the items id

Anyway im not sure how to do much else with them besides get the values out. :bemused:

Any help with this would be great!

Richardtagger

what part arent you sure of..? you mean you want to query the db and produce an array... then compare them?

andymate

Ok basically the table shows three things

The items name
the items quantity
the items id

these are loaded by the databse

The items quantity can be changed in a forms which load the number out of the db in this table.

i want to be able to change any of the products quantities and press one button which will change them all to the new quantities in the database..

** richard yes compare the quantity values and then change in the db if needed.

leatherback

Hi,

In ptinciple you do not even need to check whether they have to be chanced, unless you keep track of date of change etc.

You can just run an update query in your foreach loop, instead of creating the arra (Unless again, you have a need for the array).