Dropdown option with multiple value (LIKE %)

Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Dropdown option with multiple value (LIKE %)

flyboeing 13 Jun, 2019

Hi all,

I have a chronoform for searching my database. I have a dropdown menu where you can select the section (Military or Civil).
In my database, the section column is filled with Military or Civil, but some rows contains a space behind the text (Military% or Civil%).

Showing the data is no problem, using the following condition in CCv5:

<?php
return array("section LIKE" => "%Civil%");
?>

But how do I translate this to the dropdown menu? (<option value="military">Military</option>)

Regards,
Ruud

GreyHead 14 Jun, 2019

1 Likes

Hi Ruud,

The simplest answer is probably to clean up the data in the table rather than trying to work round it.

Bob

This topic is locked and no more replies can be posted.