It's ABC order, you can easily change that if you want to, I usually use.
PHP Code:
<?php
settype($sortby,"string");
if ($sortby == "") {
$sortby = Category;
}
if (($sortby == "Date") OR ($sortby == "Rating")) {
$sortbyOrder = "DESC";
}
else {
$sortbyOrder = "ASC";
}
?>
And then let MySQL query like this.
PHP Code:
<?php
$TutList = mysql_query("SELECT * FROM Tutorials order by $sortby $sortbyOrder LIMIT $startpoint,4");
$TutListNext = mysql_query("SELECT * FROM Tutorials order by $sortby $sortbyOrder LIMIT $startpointNext,4");
$totalNext = mysql_num_rows($TutListNext);
?>
I included the LIMIT $startpoint,4 part to show you how you can do that smoothing tutorials out over several pages
PHP Code:
<?php
settype($page, "integer"){
$startpoint = $page * 4;
$startpointNext = $startpoint + 4;
?>
Then with a WHILE loop you can call the tutorials.
To make those Previous and Next links.
PHP Code:
<?php
if ($page > 0) {
?>
<a href="<? print $PHP_SELF ?>?page=<? print $page-1 ?>&sortby=<? print $sortby ?>"><<< Previous 4</a>
<?
}
if (($page > 0) && ($totalNext > 0)) print " - ";
if ($totalNext > 0) {
?>
<a href="<? print $PHP_SELF ?>?page=<? print $page+1 ?>&sortby=<? print $sortby ?>">Next <? print $totalNext ?> >>></a>
<?
}
?>
I'm not sure if I'm right, I'm not a PHP expert but do know some things.
And I know you didnt want to code be written out, but I think this is the best way to learn =\
Other people probably do it different, but I do it like this.
Anyways, good luck 
*keeps thumbs crossed and hopes he's right*
EDIT: Whooops, forgot one thing, your URL would look like:
http://www.yourdomain.com/list_categ...ry=HTML&page=0
Bookmarks