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,
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
