Max Values in array

[Anon]

I have a script that will read a directory and display thumbnails. It works great, but I need to only display 12 images per page so I want to add next/prev links.

I was thinking about reading the directory into a session array and then using that to generate next/prev links. What is the max number of values that can be put into an array. Will doing this eat up tons of resources?

Is this the best way or is there something better I should be looking into??

[tappy]

i would use mySQL's LIMIT function (if you are mySQL'ing there)

mysql_query("SELECT * FROM thumbnails LIMIT 0,12") ;

that would show 12 results from the first record in the db...

you could then have
mysql_query("SELECT * FROM thumbnails LIMIT 12,12") ;
to display the next 12

or have it as a variable to make it a lot easier

if(!isset($next))
{
$from = 0 ;
}
elseif(isset($next)) {
$from = 12 * $next ;
// for example, if $next was 3, then it would mean the 3rd set of results.. i.e. show 12 from the 36th

mysql_query("SELECT * FROM thumbnails LIMIT $from,12") ;

print "<br><br>" ;

$last = $from + 12 ;
$next_lot = $last + 1 ;
print "You are viewing results $from to $last - click <a href=\"<?=$PHP_SELF?>?next=$next_lot\">here to see the next 12</a>.";
}

or something simular...

[tappy]

the next link and the actual getting out of the database are working in 2 different ways (i.e. that wont work)

but thats the general idea...