Sort problems

I have a table which displays my records. In column user (in my database) i have a number (user id) but when i display my results it displays names of those users (in my repeat region). (using INNER JOIN) So now i want to apply sorting on each of my table columns and it does not sort users by name, it sorts them by this user id stored in the database. How can i sort those records by user names, not ids?

Thanks in advance

Edit the recordset, by default every recordset sorts with the primary key you can tel it to sort by what ever field you like


example:

$query_name = "SELECT ID, User_names, otherfields FROM Tablename ORDER BY User_names ASC";

Good luck

Thanks for your quick reply Sades

I want to use the sort option from dataassist so if someone clicks on the column Usernames i want to display records ordered by usernames not user ids. I want to apply this on every column. So default recordset ordering is not option. I still have no idea how to do this.

see the "Sorting by column links" tutorial in the solution recipe section of the DataAssist support page:
dataassist/