[PHP] NEXT Page and BACK Page

2001-10-23 Thread Tshering Norbu
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

Re: [PHP] NEXT Page and BACK Page

2001-10-23 Thread Rasmus Lerdorf
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

[PHP] Again: [PHP] NEXT Page and BACK Page

2001-10-23 Thread Josep Raurell
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

[PHP] Re: Again: [PHP] NEXT Page and BACK Page

2001-10-23 Thread Rasmus Lerdorf
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

[PHP] NEXT Page and BACK page

2001-10-22 Thread Tshering Norbu
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