I am working on a PHP script where a data grid is shown; from here, user can select a row (or record) which is then opened in a window.
Once in the window, user can edit and save the record. Saving the record barely flashes and shows message saying that record has been successfully changed.
I want to give the user the option to click on a NEXT button to move to next record in the table or PREVIOUS to move to previous record in the table while in "full record view mode".
Here is the catch, the data grid holds the recordID which is used to open record by windowed script. On the grid, the records are sorted by NAME and so when pressing NEXT and/or PREV, I need to go to the record corresponding to the alphabetical order not the ID.
To make matter worst, the NAME is not UNIQUE.
My initial idea is to query by name where id equals ID start x,y but I get the feeling that this is not right, I just cannot put my finger on it.
Any suggestions?
Regards,
Jose
Once in the window, user can edit and save the record. Saving the record barely flashes and shows message saying that record has been successfully changed.
I want to give the user the option to click on a NEXT button to move to next record in the table or PREVIOUS to move to previous record in the table while in "full record view mode".
Here is the catch, the data grid holds the recordID which is used to open record by windowed script. On the grid, the records are sorted by NAME and so when pressing NEXT and/or PREV, I need to go to the record corresponding to the alphabetical order not the ID.
To make matter worst, the NAME is not UNIQUE.
My initial idea is to query by name where id equals ID start x,y but I get the feeling that this is not right, I just cannot put my finger on it.
Any suggestions?
Regards,
Jose