Limited

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

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

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

Daryl Maximo
PHP Programmer - interactivetools.com