Posted by endlesstide on 04/11/06 12:47

Ok, table has thousands of records. Each record has a unique ID and a
dynamic number that could be anything. From a efficiently standpoint
(given there will be lots of transactions against this) --- how would I
query the database and request the first 50 records, sorted by
ascending value? - and also how would I query the database for a
certain set of records by Unique ID such as 250 thru 300 --- and see
those records in ascending order -relative- to the total record set?

Thanks so much if someone can tackle this rather tricky requirement.
Best regards, Dave

• Next in forum: finding operating system using php
• Prev in forum: Re: LONGBLOB, Textarea question. Can't seem to post more than a few thousand lines....
• Thread view: I have a tricky MySQL Query

[Reply to this message]