Hi Sommai.
On Mon, Jun 11, 2001 at 04:52:01PM +0700, Sommai Fongnamthip wrote:
> 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
In PHP, I used something like this:
query("select * from table limit $x,25");
while ($row=$db->fetch_array($result))
{
echo $row[column];
}
$next = ($x+25);
echo "Next\n";
?>
So that's the idea...
Leon Mergen
[EMAIL PROTECTED]
President of Operations
BlazeBox, Inc.
T: +31 31 735 03 03
F: +3
Try Limit 10,10 then Limit 20,10 or is it the other was around limit 10.20!
Well some thing like that..
Hope this helps
Simon
-Original Message-
From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 10:52
To: [EMAIL PROTECTED]
Subject: query to display per page
Dear,
