require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php"); $APPLICATION->SetTitle("список сотрудников (тест)"); ?> $dbcnx=@mysql_connect("192.168.1.7","peskova","gtcrjdf"); mysql_query("/*!40101 SET NAMES 'utf8' */") or die("Error: " . mysql_error()); @mysql_select_db("t3site",$dbcnx); if (empty($_GET["soort"])) $_GET["soort"]="ASC"; if (empty($_GET['company'])) $_GET['company']=1; $query="select `id`,`name`, `lastname`, `patronymic`, `g_num`, `in_num`, `m_phone`, `r_num`, `position`, `email`,`department`, `building`,`path` FROM personal WHERE `company`=".$_GET['company']; if (!empty($_GET['field'])) $query.=" ORDER BY ".$_GET['field']." ".$_GET['soort']; else $query.=" order by lastname ASC"; //echo $query; $data=mysql_query($query); $loc="tesst.php?build=".$_GET['build']."&company=".$_GET['company']; $output="