Let me try to explain the problem i am having:
I have a table of products, and a table of images (each image has a "prod_id" field that tells me which product belongs to).
Now when I display the images for a particular product I want to be able to "order" the images, selecting which one must be displayed first, which one as second and so forth.
To do this each image has a "position" integer field that is originally set to be equal to the imageID, so that the images are actually shown in the chronological order of insertion.
Now I wish to make a php page that displays for a particular product (the product ID $prodid is passed to the page through the URL) all the images with their "position" value and next to each picture having a text field that allows me to enter a new integer value.
I want one single submit button at the bottom and when clicked it updates ALL the position fields of the images in the page. I need the processing to be done in the SAME PAGE and redisplaying the same list of images updated depending on the new position values.
I am a little lost... any help please??