Hi to everyone, this is my first post here and comes out of pure frustration and desperation :-|
I am trying to retreive all the items from a multi lined textarea on a form, then after selecting each one run a db update to that item in the db.
Sounds pretty straightforward to me ....
So far I am able to echo each item from my exploded list and they all show correctly.
Now the bit I am stuck with is getting each item in turn updated in the db.
It will only update the last item in the list no matter what I do.
I have tried while, foreach, do while, for, etc but no matter what I try I cannot get it to update more than the last one.....
I am presuming that my update statement cannot execute due to each item not being seperated enough so it is just selecting the last in the list.
If there is only one item then it works just fine and the update executes.
more than one and it just updates the last in the list!
If any of you people out there in the ether can point me in the right direction I would be eternally greatful.