Can anybody help me please? Bob Im sure you know the answer! Following your templates I used the two snippets in two forms - one for filtering only records with value "2" and the other to make filter input/submit command for the table. When I tried to combine these two, it fails - is it possible to combine these two snippets (below) together in WHERE SQL filed of the CC?
As it is now, it only shows records with "2" but after dynamic filter is applied, it brings up error saying that the second syntax is somehow wrong.
Thank you for help!
Jiri
As it is now, it only shows records with "2" but after dynamic filter is applied, it brings up error saying that the second syntax is somehow wrong.
WHERE `availability_calendar_units_id` = 2
<?php
$title = JRequest::getString('title', '', 'post');
if ( $title ) {
echo " WHERE `title` LIKE '%$title%'
OR `enddate` LIKE '%$title%'
OR `startdate` LIKE '%$title%'
OR `description` LIKE '%$title%' ";
}
?>
Thank you for help!
Jiri