1.

Solve : pagination: Help!!?

Answer»
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
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.


Discussion

No Comment Found

Related InterviewSolutions