in fact.. how to goTo next/previous row of a table without using
incremental ids AND without reading the whole table?
i will explain:
I wanna do something like a paging toolbar blinded to a list of rows
(for example, a literally view of a db table).
The first difference from a normal paging system, is that i wanna show
only one row per page, and luckily i know the id of that first viewed
row; so, no problem until here. Im able to show the first row xD.
The second difference is that i don't know the position of the first
viewed row inside the whole original table, only the id of the row
(maybe someone is laughing while reading 'only').
I would like to know the position of that row to allow a easy goTo
next/prev method using LIMIT/OFFSET sql clauses.
Assuming the row id you have is a primary key, you could do:
select * from table where primary_key > $current_rowid order by
primary_key asc limit 1;
For previous you could do:
select * from table where primary_key < $current_rowid order by
primary_key desc limit 1;
Postgresql & php tutorials
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php