Help W/ previous/Next links

[agentvic]

I did some searching but couldn't find anything I could work with.
I'm wanting to have page numbers, previous, next links to separate results from my database (10 at a time).
If anyone can help with some code to use with this it would be greatly appreciated.

Thanks

Here's the code I'm using:

<?PHP
$db = mysql_connect("localhost","user","pass") or die("Problem connecting");
mysql_select_db("gallery") or die("Problem selecting database");
$query = "SELECT * FROM users ORDER BY name LIMIT 0, 10";
$result = mysql_query($query) or die ("Query failed");
//let's get the number of rows in our result so we can use it in a for loop
$numofrows = mysql_num_rows($result);

echo "<TABLE WIDTH=\"100%\" BORDER=\"0\">\n";
echo "<TR bgcolor=\"lightblue\"><TD>Name</TD></TR>\n";
for($i = 0; $i < $numofrows; $i++) {
    $row = mysql_fetch_array($result); //get a row from our result set
    if($i % 2) { //this means if there is a remainder
        echo "<TR bgcolor=\"#F8F8F8\">\n";
    } else { //if there isn't a remainder we will do the else
        echo "<TR bgcolor=\"white\">\n";
    }
    echo "<TD>Name: ".$row['name']."<br>Email: ".$row['email']."<br>Location: ".$row['location']."<br>Website: ".$row['site']."<br>Info:<br>".$row['info']."<br><div align=\"center\"><img src=".$row['image_1']."><br><img src=".$row['image_2']."><br><img src=".$row['image_3']."></div></TD>\n";
    echo "</TR>\n";
}
//now let's close the table and be done with it
echo "</TABLE>\n";
?>

[PhaZZed]

I presume you are familiar with sql statements, mysql in particular; There is a command LIMIT 0, 10 which is in your code, this reads 10 results out of the table, so what u need to do is instead of placing 0, 10 place $var1, $var2.

Then you make links which pass those variables to the file and change the values, ie moving down and down 10 by 10 🙂

hope thats helped, there is code in the code gallery somewhere on phpbuilder.com 🙂