dcsimg
A Flash Developer Resource Site

Results 1 to 2 of 2

Thread: splitting up pages for thumbnails in php

  1. #1
    Bearded (M|G)od MyFriendIsATaco's Avatar
    Join Date
    Dec 2002
    Location
    Awesomeville.
    Posts
    3,046

    [resolved]splitting up pages for thumbnails in php

    i was wondering the approach other people take to doing this. i want 9 thumbnails per page. what i've done in the past is just for each page, it makes a call to the database and grabs every entry, then only uses the ones it needs. is that the most efficient way? is there a way to grab the total number of entries in a table? and is there a way to select say entries 9-17 only?

    thanks.

    [ps] i want the pages in the format of photos.php?page=2
    Last edited by MyFriendIsATaco; 05-18-2006 at 04:10 PM.

  2. #2
    Bearded (M|G)od MyFriendIsATaco's Avatar
    Join Date
    Dec 2002
    Location
    Awesomeville.
    Posts
    3,046
    ahh, i solved my own problem, i found out the complete syntax for LIMIT:

    LIMIT start_row, how_many_rows

    and i can use COUNT(*) to grab the total amount of rows.

    Thanks anyways!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center