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
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
By Daryl - June 5, 2013
Would you mind filling up a 2nd level support request form so we can take a closer look?
The form can be found here: https://www.interactivetools.com/support/email_support_form.php
Thanks!
Daryl
PHP Programmer - interactivetools.com