In PHP, I used something like this:
<?
$result = $db->query("select * from table limit $x,25");
while ($row=$db->fetch_array($result))
{
echo $row[column];
}
$next = ($x+25);
echo "<a href=\"script.php?x=$next\">Next</a>\n";
?>
So that's the idea...
Leon Mergen
[EMAIL PROTECTED]
President of Operations
BlazeBox, Inc.
T: +31 31 735 03 03
F: +31 31 735 03 08
ICQ: 55677353
************************
The information transmitted in this email is intended only for the
person(s)or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. If you
received this email in error, please contact the sender and permanently
delete the email from any computer.
----- Original Message -----
From: "Sommai Fongnamthip" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 11:52 AM
Subject: query to display per page
> Dear,
> I am preparing my web page to display search result. How could I use SQL
> command to handle display specific row per page and next button at the
> bottom page (like most search engine display result).
>
> Sommai Fongnamthip
>
> Remark: Could I use this SQL command with PHP or perl?
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
