Does anyone know how to achieve this using non-mysql servers? subqueries?
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 7:48 PM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] How to do this with PHP
SEL
On Friday 21 September 2001 21:47, Rick Emery wrote:
> SELECT * FROM mytable LIMIT 0,5
> SELECT * FROM mytable LIMIT 6,5
> SELECT * FROM mytable LIMIT 11,5
> SELECT * FROM mytable LIMIT 16,5
It is advised to add
ORDER BY _col_name_here_
to guarantee the order of rows retrieved (otherwise, you
SELECT * FROM mytable LIMIT 0,5
SELECT * FROM mytable LIMIT 6,5
SELECT * FROM mytable LIMIT 11,5
SELECT * FROM mytable LIMIT 16,5
-Original Message-
From: Alawi Albaity [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 1:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] How to do th
