Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: pagination: Help!!  (Read 2908 times)

0 Members and 1 Guest are viewing this topic.

r3ynz_t4nz

    Topic Starter


    Beginner
  • A programmer is a king
    pagination: Help!!
    « on: December 07, 2008, 05:53:08 PM »

    anyone can explain this query to me?

    $page_limitvalue = $page * $page_limit - ($page_limit);
                   
    $sql = "SELECT *FROM blogs ORDER BY blogs_id DESC LIMIT $page_limitvalue,          page_limit;";

    i  cant figure out,.. especially this one: "LIMIT $page_limitvalue, page_limit"

    thanks in advance.,.,

    r3ynz

    kpac

    • Web moderator
    • Moderator


    • Hacker

    • kpac®
    • Thanked: 184
      • Yes
      • Yes
      • Yes
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 7
    Re: pagination: Help!!
    « Reply #1 on: December 08, 2008, 10:40:45 AM »
    As far as I know, it tells MySQL to order the blogs by the ID of the blog in descending order, but the ID of the blog has to be between the variable $page_limit value and $page_limit.