54 Posts
nzimas
10 years ago
1
Topic
I've created a text field called field_length where users input numerals.
The data is stored in its own field_length column in #__cck_store_item_users.

Then I've set up a dynamic select list in the search form to retrieve values from that column-
I would like the select list to display options by range, instead of absolute values, that is to say:

-1 to 20
-21 to 40
.> 41

Think you get the idea.

How would the full SQL statement look like to make this possible?



Get a VIP membership
54 Posts
nzimas
10 years ago
0
Level 1
The Numeric select list would be perfect if it could draw values from a specified table.
It pretty much does what I have in mind, except that it won't query columns other than the one where it stores values, meaning that the input must be a range too, instead of a single value store from an input text field.
Get a VIP membership