How to set next/previous page by limit

edikasim81

I success run script below to show current rows in my table...
But my problem is if the table had more than 10 and above rows data how can the script show only 10 rows per page.

<?
include '../dbase.php';

$query = "SELECT * FROM community";
$result = mysql_db_query($dbname,$query);

$row = mysql_fetch_array($result);
$name = $row["name"];
$address = $row["address"];
$email = $row["email"];
$phone = $row["phone"];

$age = $row["age"];
?>

<li>
Name : <? echo $name; ?> 
Address : <? echo $address; ?> 
Email : <? echo $email; ?> 
Phone Number : <? echo $phone; ?> 
Age : <? echo $age; ?> 
</li>

TheDefender

Search these forums for "pagination" (sans quotes). This particular topic has been covered many many many times in the past.

On a side note, I don't see how you are getting more than one result out anyhow, since you aren't looping through your fetched array. The code you have here is only going to show the last record.

Frederick

You can find what you are looking for in the Cheat Sheet attached to this article/thread.
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10293563