silly sql question...

date posted 8th April 2001 08:16

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