get("name") . "', main_contact.email AS '" . $translation->get("email") . "', main_department.description AS '" . $translation->get("top_department") . "' FROM main_contact LEFT JOIN main_contact_department ON main_contact.id = main_contact_department.main_contact_id LEFT JOIN main_department ON main_department.id = main_contact_department.main_department_id GROUP BY main_contact.id, main_contact.name, main_contact.email ORDER BY main_contact.name ASC"; // var_dump($query); $format = array("option", "text", "text", "text"); if ($result = mysqli_query($GLOBALS['mysql_con'], $query)) { linklist($result, "form_contact_list", $format); } ?>