Hi,
I need to use the "View as"-"Custom Code" on the list page to show number of agents from an table witch isnt in the default database of the PHPRunner project.
How can i do that?
My code on the "View as"-"Custom"
$sql = "select
count(agent_id) AS agenter,
group_id
from grp_agent
WHERE group_id = $value
Group BY group_id";
$rs = CustomQuery($sql);
$data = db_fetch_array($rs);
$value=$data["agenter"];
As my "other" database is named ecc i have tried with
from ecc.grp_agent
But as that doesnt work (Table 'ecc.grp_agent' doesn't exist) i guess that its not that simple?