Hi,
i have a test setup with postgresql 7.2, PHP 4, and apache. everything
works fine, PHP generates HTML pages with query results in it. now i
want to create a simple form which shows the current record, and has
these buttons:
- previous, first, next, last record
- delete record
- add record
it sounds very simple, but where do i start? i guess i should make a
stateless connection (the form will be accessed via the web). i figure
i need some sort of recordset, is a CURSOR the right approach? maybe
someone can point me to an example?
For the previous / next buttons, I use 'LIMIT / OFFSET' with the queries.
For example to show 10 records each page,
on the first page:
query = SELECT ..... LIMIT 10 OFFSET 0
the second page:
query = SELECT ..... LIMIT 10 OFFSET 10
etc
For adding or deleting a record, you'll have to do up a form of some type
to get the data.
I'll leave the practicalities to you :)
-----------------
Chris Smith
http://www.squiz.net/