multipul page db query result printing

[juru]

I have one simple problem.
Could any body explain how exactly I should
organize multipul page result printing.
Say, I'm doing request and getting result from database
of about 100 rows. Please, write a script to organize those
100 rows by 10 per page.
Thanks.

[dar-k]

Originally posted by juru
I have one simple problem.
Could any body explain how exactly I should
organize multipul page result printing.
Say, I'm doing request and getting result from database
of about 100 rows. Please, write a script to organize those
100 rows by 10 per page.
Thanks.

$50 will do, unless someone else can do cheaper.

As for an explanation, try using LIMIT in your query and run it with new arguments for each new result page.

[juru]

Well, LIMIT clause doesn't fit, because
I don't use MySQL. Is there any alternative
for LIMIT clause, because I'm using Access db
through ODBC.😕

[dar-k]

Store the results in a session array and filter that out with a query string.

script.php?page=1
gives results 1-10

script.php?page=2
gives results 11-20

for filtering try a 'for' loop: http://www.php.net/manual/en/control-structures.for.php

[juru]

Session array is quite good solution. Thanks much.
Aaa.. Is there any other alternative that won't upload
my server with result array. I mean, what if there will be
1 million row result, so I'll have to put all of them in to
array? Well it seems that cost is too high.:rolleyes: