Next record........

Anon

If I have a set of records with non-sequential id numbers, how do I go about retrieving the next record so that a user can browse through each record in the table sequentially?

If the id's were sequential, I would just increment the id in the WHERE clause. But can't do it that way.

Thanks in advance!

jhonrputra

Hi.

To retrieve the records for browsing each record in sequentially [which they are actually not sequentially ordered], perhaps we can do :
a. Set the SQL statement:
"select * from mytable order by id"
b. This will give us records sequentially ordered. Then we can add some codes that have variables to specify the range of records [just like DBNavigator on Delphi].
c. How about by setting the field as key, Indexed and Unique?

Good luck! Please let me know if this solve the problem.

Best Regards.
Jhon R Putra

Anon

wouldn't this mean that every record in the table would have to be retrieved on every search page? If I want to view product #1 then 2 on the next page, etc, I don't want to have to retrieve every record for every page.

I'm new to this db stuff and don't know too much about indexes..........

jhonrputra

Hi.

Not like that.
Before retrieve the result, select some records [that you haven't show up] by specify the range. Then you retrieve the records on the range to user. For next result, make the old highest range as new lowest range, then increment by some point for your new highest range. This range will be the link [like ../myrec.php?first=10&last=20...]

;-)

kparker

A LIMIT clause in the SELECT statement will cause only the specified number (and starting relative row) to be returned. Whether the dbms will have to internally produce and discard any rows that are less than the starting relative row depends on the parameters of the query, the existence of indexes, and the goodness of the query optimizer. In short, YMMV.