RE: FN-FORUM silly sql question...

date posted 8th April 2001 09:25

SELECT * FROM table LIMIT 10, 20;



-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Rick [Kitty5]
Sent: 06 April 2001 15:41
To: List [FN-Forum]
Subject: FN-FORUM silly sql question...


Hi all,

I am just wondering if there is a better way of doing this.

I need to select X number of records from a table, i do not know any of the
values of the data in advance, so cannot use a where statement selecting all
records between 2 primary key values

so far i am selecting all the records, and using a loop to skip through to
the required record, then reading the X number of records i want off to the
page, then exiting the loop, and closing the data.

can i using sql just select records 10 to 20, or 15 to 25 etc ?

Rick

Kitty5 WebDesign - http://Kitty5.com
Hi-Impact database driven web site design & e-commerce
TEL : +44 (01625) 266358 - FAX : +44 (01625) 611913 - ICQ : 15776037
POV-Ray News & Resources - http://Povray.co.uk

PGP Public Key
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x231E1CEA







============================================================

* Free listing for freelancers
* Free to advertise jobs
* Free jobs distribution service
* Free database of 1000 freelancers

Freelancers and Freelance Jobs
http://www.freelancers.net

To post to the Forum:
[EMAIL REMOVED]

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]

To subscribe to the digest for this list or for further information please
visit:
http://www.freelancers.net/forum.html