asktom.oracle.com has a great article about paging web
results.
http://asktom.oracle.com/pls/ask/f?p=4950:8:544834::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:76812348057,%7Bpaging%7D%20and%20%7Bresults%7D
kind of a hairy url, but it is from his archives on
January 20.
it details two approaches, one where you repeat the
initial query all the time (if it is small), and one
that uses a temp table to store the results for the
query if the results set is large.
great article and site.
Job
--- Jason Wilkes <[EMAIL PROTECTED]> wrote:
> Hi folks,
>
> I'm not a DBI newbie, but am struggling with some
> code.
> I can happily make a select field1, field2 and
> return
> all rows to a web page.
> However I want to return only a partial number of
> rows
> ( say 5 ) on successive pages - much like a search
> engine (where page 1 give results 1-10, and a link
> to
> page 2 gives rows 11-20 etc etc).
>
> I think I need to use fetchrow_arrayref with
> something
> like
> for ($count = 0; $count < 10; $count++){
> $data = $sth->fetch[$count];
> ....do something with $data
> }
> however I can't get the desired effect ((my personal
> opinion in an otherwise execeleent book ;-) is the
> o'rielly book is a bit vague also))
>
> Does anyone have any pointers or even a code snippet
> ?
>
> it would be much appreaciated
>
> Tory.
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
