display 10 entries at a time from mysql

Anon

I would like to know how you can display 10 entries at a time from the database. Once 10 entries have been shown a forward button must appear at the bottom of the results prompting the user to goto the next 10. On the second page of results a back button should appear and so on, I think you know what I mean. . I have copied and pasted the code from my page that gets the results from mysql database.

Here is my code:

<?php

$connection = mysql_connect ("domain_name","password", "user");
if ($connection == false){
echo mysql_errno().": ".mysql_error()." ";
exit;
}

$query = "select * from greatbritain";
$result = mysql_db_query ("name_db", $query);

if ($result){
echo "<center><img src=key.gif> ";
echo "<center><img src=strip.gif><center> ";
echo "<table width=20% border=0 cellpadding=0 cellspacing=0>";

$numOfRows = mysql_num_rows ($result);
for ($i = 0; $i < $numOfRows; $i++){
$country = mysql_result ($result, $i, "country");
$region = mysql_result ($result, $i, "region");
$towny = mysql_result ($result, $i, "towny");
$descy = mysql_result ($result, $i, "descy");
$tel = mysql_result ($result, $i, "tel");
$mobile = mysql_result ($result, $i, "mobile");
$email = mysql_result ($result, $i, "email");
$linky = mysql_result ($result, $i, "linky");
echo "<link rel=stylesheet type=text/css href=General.css>";
echo "<body bgcolor=#324F8F><tr><img src=country.gif align=absmiddle alt=country>$country</tr><tr><img src=region.gif align=absmiddle alt=region>$region</tr><tr><img src=town.gif align=absmiddle alt=town>$towny</tr><tr><img src=details.gif align=absmiddle alt=description of rental>$descy</tr><tr><img src=telephone.gif align=absmiddle alt=telephone number>$tel</tr><tr><img src=mobile.gif align=absmiddle alt=mobile number>$mobile</tr><tr>";

if ($email){
echo "<a href=mailto:$email><img src=email.gif border=0 alt=email></tr></a>";
}

echo "";

if ($linky){
echo "<a href=$linky target=_blank><img src=webpage.gif border=0 alt=website></a>";
}

echo "</tr> <center><img src=strip.gif> ";

}

mysql_close ();

sarahk

check out the command to mysql and lots of the articles on this site. You can limit the range of records returned on a list.

iifs044

Check out adding a LIMIT clause to the end of your SELECT statement. For example:

SELECT * FROM inventory ORDER BY partnum LIMIT 10

will return the first 10 inventory items, as ordered by part number. You could also use:

SELECT * FROM inventory ORDER BY partnum LIMIT 10, 11

which is almost the same, except that you get items 11 through 20, instead of 1 through 10 (first example).

The way to implement this is to dynamically create your <next> and <prev> links on each page to include the desired starting point in the database (i.e. the second parameter to LIMIT).

-- Mitch