dct4master
New Member
I am using PHP/MYSQL. I want in my frontend, for the users to sort and rearrange database records entered by the user himself in an earlier stage. The records uploaded by the user may sometimes inserted into the database randomly, so in the user profile he/she might have a facility to rearrange the the rows in the database according to there wise. Can any one provide me a script that would help me to do so.\[code\]id title date desc1 s1 s1_date s1_desc2 s2 s2_date s2_desc3 s3 s3_date s3_desc4 s4 s4_date s4_desc5 s5 s5_date s5_desc\[/code\]In the user profile he want to rearrange the rows so that s2 will go one up and will save as s2->s1 and s1->s2 for every field.. may be swapping of records in betweenI am looking it in another way.. user page will show the field in rows wise and in the side there will be an input box of each the current row id say (id) is set as value of that input box so that the user can change in between and submit the whole reordered list to the back-end. In that case what can we do... there will be many swapings to to concurrently..