[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 th

[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 s

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

[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 additio

[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.ne