Hi, I am new to PHP and Mysql but am really determined to learn these techniques. I have some script that reads and displays results from the databse onto a page. However, I really wish to limit the number of results that are displayed to 10 per page and then have the next/privious links under the results. With these results, the results under the email field should be hyperlinked so that the person viewing the results should double click on the email link and send the person an email. How can i do that? I have to learn this technique.

The code is:-

<p><?php
$server = "localhost"; // server to connect to.
$database = "dbdbdb"; // the name of the database.
$db_user = "dddd"; // mysql username to access the database with.
$db_pass = "pppp"; // mysql password to access the database with.
$table = "alumni"; // the table that this script will set up and use.
$rows = 20; // the number of table rows to display
//
$link = mysql_connect($server, $db_user, $db_pass)
or die ("Can't connect" .mysql_error());
//
mysql_select_db($database)
or die ("Can't connect" .mysql_error());
//
$sql="SELECT fullnames, company, address, email FROM $table";
// open the table and print a header row.
echo "<table align=center width=500>";
echo "<tr bgcolor='#FAC88B' class='NiceSmallBold' style='font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px'><th>Full Names</th><th>Company</th><th>Address</th><th>E-mail</th></tr>\n";
if ($result=mysql_query($sql)) {
  while ($row=mysql_fetch_row($result)) {
    echo "<tr bgcolor='#FDE9D0'><td style='font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px'>".$row[0]."</td>";
    echo "<td style='font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px'><p align='center'>".$row[1]."</td>";
    echo "<td style='font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px'><p align='center'>".$row[2]."</td>";
     echo "<td style='font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px'><p align='center'>".$row[3]."</td></tr>\n";
  }
} else {
  echo "";
}
echo "</table>";
// close database connection
include("closedb.php");
?></p>

-----------------------------------

Thanks ALL

Haaaa Previous // Next // Page 1 2 3 4 5
Took me 1 day to work that one out.. it's mathematical more than anything else
1) query your table so you know how many rows you have stored
2) determine how many you want per page ; divide the amount of rows by that number = how many pages
3) carry a variable which tells the program which page you are on and mutiple page by amount of result per page so you know the row number of the 1st row to display
4) use something similar to this:
$query = "SELECT * FROM Table_name WHERE Article_Date BETWEEN '$SearchDate1' AND '$SearchDate2' ORDER BY Article_Date DESC";
  $result = mysql_query($query)
       or die ("Problem encounter ".mysql_error());
  while ($row = mysql_fetch_array($result))
  {
     extract($row);
.
.
.
.
}
Get some coffee you will need it :)