Odp: [PHP4BETA] range
| From: | Lukasz Felsztukier | Date: | Mon, 14 Feb 2000 01:36:01 +0000 |
| Subject: | Odp: [PHP4BETA] range | ||
| References: | 1 | Groups: | php.version4 |
| Request: | Send a blank email to php-version4+get-10233@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: mike@stratabase
To: php4beta@lists.php.net
Sent: Sunday, February 13, 2000 2:32 PM
Subject: [PHP4BETA] range
>can you use therange function in a query? Say i have an autoincremented
field called entryID and in a form i am giving the user the ability to
select the range >of how many results to spit back.. so they could select
the range of entryID to be 34 - 766... can i use the range function on a
query to process that request??
I'd do something like:
SELECT * from some_table LIMIT x,y-x
where x is starting row, and y ending row
Cheers,
Luke