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
Use a LIMIT clause. See
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT
-Rasmus
On Tue, 23 Oct 2001, Tshering Norbu wrote:
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
Use a LIMIT clause. See
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT
-Rasmus
And for a db that not have limit (like ibm db2)
Josep.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Use a LIMIT clause. See
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT
-Rasmus
And for a db that not have limit (like ibm db2)
Use a cursor or rowcount, if you have that.
-Rasmus
--
PHP General Mailing List (http://www.php.net/)
To
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
5 matches
Mail list logo