I have a table in a database. The primary field is ID Int(11) auto_increment. The public display of the table sorts the table by ID. I have a back-end member area where a member can log in and add a new record to the table. This new record displays on the front-end at the bottom because it is automatically inserted at the bottom of the table with the highest ID number.
As I said, the front-end display is set to sort by the primary field (ID). This is why new records are displayed at the bottom. I could change the sort to be based on one of the other fields in the table, but none of them suit what I would want after a member adds a new record.
Is there a way to allow the member who is entering the new record into the form to set where that new record will be displayed in the list on the front-end?