Submitting several changes

[Anon]

Hey,

I got this list:
http://www.demonews.com/mc/sidan.jpg
It's driven by a database. And I want changes made to it to be submitted to the database. But I just can't find out how!
The field names are:
filename, delete, description
it is being submitted to dofileedit.php
In there I need to know what to type for all the changes made on the first page (ref to image) to be submitted to the database.

Please help me. I'm all out of ideas.

Thanks,
Johnny

[jordan]

To make changes to an existing record in an (My/MS/Postgre)SQL database, use UPDATE. You may have to run multiple queries to make numerous different changes to numerous records.

[Anon]

Yes, I know that.. but HOW is my question 🙁 I'm so far a beginner with PHP.
This is my query if I update ONE picture:
$query = "UPDATE pix SET description=$newdescription WHERE id = '$pic_id'";
but since I'm updating several in the same time I don't know how to do it.
Please help me by writing the FULL -addtodatabase- script..

Got this sent to me but I never understood it:
$i=0;
while($pic_id[$i]) {
$query = "UPDATE pix SET description=$newdescription WHERE id = '$pic_id'";
$i++;
}