Hi.
I'm using ChronoForm 5.
I would like to display in a dropdown list all my content included in a specific category.
For the moment, with the action "DB read", my select shows all my content (id and title) in table joomla_content.
I would like to add a condition "WHERE catid = xx" to the SQL request.
How to do this ?
Thanks for your help.
I'm using ChronoForm 5.
I would like to display in a dropdown list all my content included in a specific category.
For the moment, with the action "DB read", my select shows all my content (id and title) in table joomla_content.
I would like to add a condition "WHERE catid = xx" to the SQL request.
How to do this ?
Thanks for your help.
Hi ChDUP,
Use the Conditions box in the DB Read action. You will need a condition like:
Bob
Use the Conditions box in the DB Read action. You will need a condition like:
<?php
return array('catid' => 'xx');
?>
Bob
Thanks GreyHead.
But I've already tried, and it just write
And my dropdown isn't affected.
I've tried with and without the "<?php ... ?>" code.
I don't understand how conditions works.
But I've already tried, and it just write
< ?php
return array('catid' => 31);
?> in the front office, above the front.
And my dropdown isn't affected.
I've tried with and without the "<?php ... ?>" code.
I don't understand how conditions works.
Hi ChDUP,
It needs to be in the Conditions box as I said.
I'm sorry, there was a typo in my code, an extra space in <?php :-(
Bob
It needs to be in the Conditions box as I said.
I'm sorry, there was a typo in my code, an extra space in <?php :-(
Bob
This topic is locked and no more replies can be posted.
