OnApplicationInit;
$arr_rows = array();
sc_select(rs, “SELECT loc_id FROM location_people WHERE login = [usr_login]”);while(!$rs->EOF)
{
$arr_rows[] = $rs->fields[0];
$rs->MoveNext();
}
$rs->Close();
//print_r($arr_rows) ;[locations] = implode (", ", $arr_rows);
SQL Query:
SELECT
id,
name,
loc_id,
description,
category
FROM
asset
WHERE loc_id IN ([locations])