Dear list,
I would like to query only the last 50 records/rows (order by ID desc) in
the following script file which uses MySQL, and I want to have NEXT page for
the 50 rows earlier than last 50 queried and go on. I think I can use
JavaScript for BACK page to go back. Could you pl add for me the script to
implement NEXT page.

Here is the script file:

$db = mysql_connect("localhost", "root", "root");
if ($id)

$result = mysql_query("select * from penpal where id = $id",$db);
$myrow = mysql_fetch_array($result);
printf("<b>ID:</b> %s\n<br>", $myrow["id"]);
printf("<b>Name:</b> %s\n<br>", $myrow["name"]);
printf("<b>Age/Sex/Location:</b> %s\n<br>", $myrow["asl"]);
printf("<b>Description:</b> %s\n<br>", $myrow["description"]);
printf("<b>Email:</b> %s\n<br>", $myrow["email"]);
} else {
$result = mysql_query("select * from penpal order by id desc", $db);
if ($myrow = mysql_fetch_array($result)) {
do {
   printf("<a href = \"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"],
$myrow["name"], $myrow["asl"]);
} while ($myrow = mysql_fetch_array($result));
}   else {
echo "Sorry, no records";

Thank you in advance.


PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to