Limited

4 posts by 2 authors in: Forums > CMS Builder
Last Post: June 5, 2013   (RSS)

By Joseph - June 5, 2013

Hi

I shall try and explain this as best as I can.

I have created a section in CMSB called Images where i have uploaded close to 1050 images. I have alsoe created a section called News and within news i have created a drop down menu called Images which allows the user to select from the images section. My problem now is the Drop down image list in News will only display the first 1,000 images and any news article accessing an image that migt be image no.1035 comes up with a number and not the image name in fact it says the image name is missing.

how can i adjust the drop down menu within the news section to display more than 1,000 images?

By Daryl - June 5, 2013

Hi Joseph,

You can display more than 1000 options in a drop down list field by setting the "List Options" in the Field Editor of your drop down field to "Get options from MySQL Query" and set a LIMIT in the MySQL query in the text area below.

For example:

SELECT num, image_name
FROM `<?php echo $TABLE_PREFIX ?>images` LIMIT 1100

Let us know if you have any more questions.

Thanks,

Daryl

Daryl Maximo
PHP Programmer - interactivetools.com

By Joseph - June 5, 2013

Thanks for the quick response tried that but no luck.

My Code:
SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>images` LIMIT 1050

when i use the code above it only gives me a list of around 100 images