Hi all
I have one table with some columns. One column is Date (YYYY-MM-DD) and other are some numeric values.
I need to show data for certain month ie: january, but I save to table date in form 2014-12-31 and I dont know how use it in dropdown.
any idea?
Thx
I have one table with some columns. One column is Date (YYYY-MM-DD) and other are some numeric values.
I need to show data for certain month ie: january, but I save to table date in form 2014-12-31 and I dont know how use it in dropdown.
any idea?
Thx
Hi homeopat,
This looks like the same question as you have in another thread?
Bob
This looks like the same question as you have in another thread?
Bob
Ho Bob,
similar, not same .... that was general about dynamic dropdown.
similar, not same .... that was general about dynamic dropdown.
Hi homeopat,
I have the same answer - if you're planning to use the month then the simplest solution is to save that column to the database as well as the date.
Otherwise you can use a Custom Code action either:
a. to build a custom MySQL query that that will extract the month from the date and GROUP BY the result; or
b. Use PHP in a Custom Code action to process the results from the CF DB Read/Load action and extract the data you need for the dynamic drop-down.
Any of these will work, which is best depends on your forms and data setup.
Bob
I have the same answer - if you're planning to use the month then the simplest solution is to save that column to the database as well as the date.
Otherwise you can use a Custom Code action either:
a. to build a custom MySQL query that that will extract the month from the date and GROUP BY the result; or
b. Use PHP in a Custom Code action to process the results from the CF DB Read/Load action and extract the data you need for the dynamic drop-down.
Any of these will work, which is best depends on your forms and data setup.
Bob
Hi Bob,
I am no sure if I understand u.
U mean add one column where name of month will be saved?
I am no sure if I understand u.
U mean add one column where name of month will be saved?
This topic is locked and no more replies can be posted.
