Sorting with pagination

[soycharliente]

Does anyone know a good tutorial to apply sorting to pagination? I don't know the best way to handle it. (Using post, get, sessions, etc.) Thanks.

[premiso]

What I do is have a drop down with "sort by" option, on change I do a post to the same change and set a session variable $_SESSION['sortby'] then add that the end of the query using the ORDER BY statement.

 

That seems to be the easiest and does not require a whole lot of code change, so if select option = 1 "ORDER BY date_added" etc...

[.josh]

Just change your column name in your tabulated data into a link that passes the column's name using the GET method, and sort by that.

 

.
.
.
$sortby = $_GET['sortby'];
.
.
.
$sql = "select blahblahblah sortby $sortby";
.
.
.
echo "<a href='wherever.php?sortby=column'>column</a>";

[soycharliente]

What I do is have a drop down with "sort by" option, on change I do a post to the same change and set a session variable $_SESSION['sortby'] then add that the end of the query using the ORDER BY statement.

 

That seems to be the easiest and does not require a whole lot of code change, so if select option = 1 "ORDER BY date_added" etc...

 

What happens if it's empty?

[soycharliente]

Just change your column name in your tabulated data into a link that passes the column's name using the GET method, and sort by that.

 

I don't have tabular data. I'm spitting out what's basically threads similar to a forum (except people can't reply). It's a page that lists announcements to a group of people. I want them to be able to sort by date, author, etc.