Computer Hope

Internet & Networking => Web design => Topic started by: r3ynz_t4nz on December 07, 2008, 05:53:08 PM

Title: pagination: Help!!
Post by: r3ynz_t4nz 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

Title: Re: pagination: Help!!
Post by: kpac 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.