theboss
Member
I have this PHP code in calculation eval element:
$db11 = JFactory::getDbo();
$query11 = "SELECT dist FROM ztl_serispest WHERE comu1 = '{zdtl_mp___it11i}' AND comu2 = '{zdtl_mp___it11f}';";
$db11->setQuery($query11);
$views11 = $db11->loadResult();
return $views11;
It works ok but return NULL when comu1 or comu2 contains this character " ' " like " PATE' ".
thanks
$db11 = JFactory::getDbo();
$query11 = "SELECT dist FROM ztl_serispest WHERE comu1 = '{zdtl_mp___it11i}' AND comu2 = '{zdtl_mp___it11f}';";
$db11->setQuery($query11);
$views11 = $db11->loadResult();
return $views11;
It works ok but return NULL when comu1 or comu2 contains this character " ' " like " PATE' ".
thanks