Hi,
I'm building a simple Booking Request form and I want to populate a dropdown list with K2 Items (actually the 'title' of the item)
K2 items belong to various K2 categories so I use the DB Read action and in Conditions entered the code below:
<?php return array('published'=>'1', ":catid='32' OR catid='55' OR catid='71' OR catid='76'"); ?>
to fetch the K2 items from 3 categories and ONLY the "published" ones
But it doesn't work!!!
What am I doing wrong?
I'm building a simple Booking Request form and I want to populate a dropdown list with K2 Items (actually the 'title' of the item)
K2 items belong to various K2 categories so I use the DB Read action and in Conditions entered the code below:
<?php return array('published'=>'1', ":catid='32' OR catid='55' OR catid='71' OR catid='76'"); ?>
to fetch the K2 items from 3 categories and ONLY the "published" ones
But it doesn't work!!!
What am I doing wrong?
Hello globerotter,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I build a WHERE statement in CCv5?
How do I build a WHERE statement in CFv5?
P.S: I'm just an automated service😉
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I build a WHERE statement in CCv5?
How do I build a WHERE statement in CFv5?
P.S: I'm just an automated service😉
You better use this:
Regards,
Max
<?php
return array('published' => '1', "catid" => array(32, 55, 71, 76));
?>
Regards,
Max
Yes!!! It worked fine
Thanks for your fast answer
Thanks for your fast answer
This topic is locked and no more replies can be posted.
