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
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
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
> 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
> > 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
5 matches
Mail list logo