Update new Image Position of Table to Database

[mukeshrasm]

Hi

I am retrieving images from database and displaying it in a table and then I am moving this images up/down. Now, I want to update new Image position which in the table now and update it to database. So How can I do this? I am able to move image up/down in table

Thanks

[rpnew]

Hi

I am retrieving images from database and displaying it in a table and then I am moving this images up/down. Now, I want to update new Image position which in the table now and update it to database. So How can I do this? I am able to move image up/down in table

Thanks

Hi,
You can use ID like column for each row in table. And once you are moving the images up/down update the ID accordingly. And select your data ordered by this ID.

Regards,
RP

[mukeshrasm]

Hi,
You can use ID like column for each row in table. And once you are moving the images up/down update the ID accordingly. And select your data ordered by this ID.

Regards,
RP

Hi
How will I do this?
And once you are moving the images up/down update the ID accordingly. And select your data ordered by this ID.

[rpnew]

Hi
How will I do this?
And once you are moving the images up/down update the ID accordingly. And select your data ordered by this ID.

Hi,
Can you provide your database structure i mean your table structure?? so that i can give a bit more details...

Regards,
RP

[mukeshrasm]

Hi,
Can you provide your database structure i mean your table structure?? so that i can give a bit more details...

Regards,
RP

Table Structure:

Image Id (int)
File Type (varchar)
File Size (varchar)
File Path (varchar)
Image Date (date)

Now you may add one more field i.e. Image Order (int) to table.

[mukeshrasm]

Hi,
Can you provide your database structure i mean your table structure?? so that i can give a bit more details...

Regards,
RP

Hi Bro how this problem will be solved If you can help me out. I have given the database structure as well.

[rpnew]

Hi Bro how this problem will be solved If you can help me out. I have given the database structure as well.

Hi,
I was out for a while.. anyways.......
What are you doing for moving images up/down on client side...?
Like i've used javascript with onclick event... I've given the checkboxes to select rows and once user selects(checks) two checkboxes they'll be interchanged.. that what i've done....
So what i'm doing here is on second click i'm taking the ID for first clicked and second clicked rows.... POSTING them to script ... and in script i'm updating their ID(interchanging).

While displaying i'm selecting then by using order by(ID) so they are interchanged on front-end and back-end as well....
If you want to do the same thing...... i can provide you more help with code.. just post back here..

Regards,
RP

[mukeshrasm]

Hi,
I was out for a while.. anyways.......
What are you doing for moving images up/down on client side...?
Like i've used javascript with onclick event... I've given the checkboxes to select rows and once user selects(checks) two checkboxes they'll be interchanged.. that what i've done....
So what i'm doing here is on second click i'm taking the ID for first clicked and second clicked rows.... POSTING them to script ... and in script i'm updating their ID(interchanging).

While displaying i'm selecting then by using order by(ID) so they are interchanged on front-end and back-end as well....
If you want to do the same thing...... i can provide you more help with code.. just post back here..

Regards,
RP

Actully I am not doing it on client side. I have given administrator to change the image position and then in the front end the changed image postion i.e. new image will be displayed. If you may give your code then it would be best for me becasuse you have explained your logic.