Forums

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

Hi Ruud,
​
The simplest answer is probably to clean up the data in the table rather than trying to work round it.
​
Bob