query the records

Hi, i have a simple form: name, age, class, country. my connection work perfectly but it show all record.
it's possible to query the records in the where box but selection are fixed. My need is query the records selecting from 4 drop downs, one for every fild of the db. Possible solution?

CC V4 e Joomla 2.5

Hi jonnyblog1976,

Use a ChronoForm as the search form and use PHP in the WHERE box of your listing to build the query you need.

Bob

Hi Bob, thanks for replay.
The form is simple, 4 drop down to select data, one submit button. But how pass data to CC to make query?
In CC, box where the Query should be like: 'name' = 'VARIABLE_PASS_BY_FORM' AND 'age' = 'VARIABLE_PASS_BY_FORM' ecc..

any tutorial,faq,forum topic you suggest me?

Hi jonnyblog1976,

I'm no expert on this version of CC. I can tell you that the FAQs document here uses a ChronoForms as the search box and the names of the inputs match up to the Search Field Name box in the listing (for the text input) and the Filters Field Names box for the Category drop-down. Though I'm not sure exactly how that happens :-(

Bob

Hi jonnyblog1976,

Could you please contact me through the "Contact us" page to get the new version, it should allow you to filter the list easily using your own form code, its still in BETA status though.

Regards,
Max