I need some reports that I made by flexi customcode module, I need to return values based on log in user and related office id like prefilter in list.
Can I use fabrikar placeholder like '{$my->id}' in SQL query?
I used the code listed below but it doesn't work:
Can I use fabrikar placeholder like '{$my->id}' in SQL query?
I used the code listed below but it doesn't work:
Code:
<?php
$db =& JFactory::getDBO();
$query = "SELECT COUNT(*) FROM `app_contracts` WHERE `contract_status` != '0' AND `adviser_id` = '{$my->id}' and office_id = '''{$q->office_id}'" ;
$db->setQuery($query);
$Result = $db->loadResult();
echo' <div class="uk-text-primary uk-text-center uk-text-bold">'.$Result.'</div>';
?>