In message <[EMAIL PROTECTED]>, Shay
<[EMAIL PROTECTED]> writes
>I’m at the “I know how to break it” stage in learning PHP and MySQL without
>having quite hit the “here’s how to fix it” point. I know my server is
>running 4.x for the versions for both PHP and MySQL. I’m hoping to pull the
>file locations of images from the database, write them in a
>three-across-by-four-down table and then create a second, third, fourth
>….page for the next group if there’s overflow. I’ve seen some pagination
>examples and I think I can figure that out. Would the same theory apply to
>the 3x4 table?
I would download all (3x4) 12 urls, at the start of the page, using
SELECT.... LIMIT (($pagenumber-1) * 12), 12
because you want as few SELECTS as possible.
Then make it something like:
loop 4 times { (for the four rows)
loop 3 times { (display each picture)
show a picture
}
}
--
Pete Clark
Sunny Andalucia
http://hotcosta.com/Andalucia.Spain
