image re-ordering

Hey Ray

On a gallery results page (attached) have got the sort order but if I want to re-order the images it doesnt put them in the right order.

So, for example in this http://prntscr.com/mn7jfr if I re-order the 3 images to 1, 2 and 3 respectively then click update, the order then looks like this http://prntscr.com/mn7k4n

Not sure what is going on?

Also, on the insert page (also attached), how would I get the inserted image to go to the top of the results list automatically?

Thanks

Jamie

I'm going to have to debug this live. Can I get a url and FTP access? I'm not spotting the problem and I need to actively debug it if I'm going to figure out where the logic breaks down.

Sure see PM

Your cmp() function appeared over-complicated. I've updated it and I think it works properly now.

Thanks Ray but if you set an image to be put in position 1, it gets added to position 2. I get that you probably have to use 0 to achieve that but is there a more user friendly way for a client just to use 1 for position 1?

I've implemented drag-drop for re-ordering on that page instead of entering order numbers. Numbers are confusing because if two images have the same order specified it won't know which is first.

cheers Ray

Have tried implementing this on an older site and have got all the actions working up to the point where when moved it sshould automatically update the db - this last bit isnt working. Have attached the page

cheers

This looks correct to me. I'd have to debug it live to see where it is going wrong... actually I think I spotted it... your page doesn't have the queryobj.php include file on it.

got it...thanks again :)