Hey swimm5001 
Heh, I can answer your Previous/Next question 
Ok, let's say you have this URL http://www.help4newbies.com/tutorials.php?page=0
First you need to tell PHP there's a $page variable:
PHP Code:
<?php
settype($page,"integer");
$startpoint = $page * 4;
$startpointNext = $startpoint + 4;
Ok, you now set the $page variable and told the string can only be a number.
Then I defined the starting point --to use in the MySQL query-- where the page should start, and I defined where the Next page should start.
Then the MySQL query:
PHP Code:
$TutList = mysql_query("SELECT * FROM Tutorials order by TutID DSC LIMIT $startpoint,4");
$TutListNext = mysql_query("SELECT * FROM Tutorials order by TutID DSC LIMIT $startpointNext,4");
$totalNext = mysql_num_rows($TutListNext);
That should explain itself I hope
$totalNext is used to check if there is a next page.
PHP Code:
Query for displaying the tutorials here using a WHILE-function
Now the Previous and Next links:
PHP Code:
<?
if ($page > 0) {
?>
<a href="<? print $PHP_SELF ?>?page=<? print $page-1 ?>">Previous Page</a>
<? }
if (($page > 0) && ($totalNext > 0)) print " - ";
if ($totalNext > 0) {
?>
<a href="<? print $PHP_SELF ?>?page=<? print $page+1 ?>">Next Page</a>
<? } ?>
Phew, hope that works, had to write this fast. Ofcourse you can sqeeuze variables in like the category and such.
Anyways, that's it for now. Help me out! Thanks
Bookmarks