SELECT code, name, thumbnail, image
FROM inventory
WHERE (category_id = 6)
ORDER BY name
LIMIT ((2-1)*15) , 3
I need this query statement to have the math calculation in the LIMIT clause to adjust for the page links.
((current_page_link-1)*maxrows/pg)
It keeps getting tossed out because of the (brackets) surrounding the numbers. Is there any way to do it?
Dfly
FROM inventory
WHERE (category_id = 6)
ORDER BY name
LIMIT ((2-1)*15) , 3
I need this query statement to have the math calculation in the LIMIT clause to adjust for the page links.
((current_page_link-1)*maxrows/pg)
It keeps getting tossed out because of the (brackets) surrounding the numbers. Is there any way to do it?
Dfly