Showing only 5 items in menu

DoPe^ · **Author**

Hey guys, just wanted to know.

I am using SQL to add items to a menu, but let's say I only want 5 items to show up, how would that be possible?

Regards

edit:

would it be by setting DESC LIMIT to 5?

Bacardi · 03-27-2013 , 06:07 Re: Showing only 5 items in menu

yes

Code:

SELECT * FROM tablename
LIMIT 0 , 5

Then next 5 items

Code:

SELECT * FROM tablename
LIMIT 5 , 5

DoPe^ · 03-27-2013 , 06:09 Re: Showing only 5 items in menu

Quote:

Originally Posted by Bacardi

yes

Code:

SELECT * FROM tablename
LIMIT 0 , 5

Then next 5 items

Code:

SELECT * FROM tablename
LIMIT 5 , 5

alright, thanks Barcardi ;)

friagram · 03-27-2013 , 09:31 Re: Showing only 5 items in menu

Not sure what your goal is, but you could show more on a single page by disabling pagination. I think it truncates at 9 menu options