query("SELECT alpha FROM companies $sql_limit order by alpha")->fetchAll(PDO::FETCH_ASSOC) as $row) {
if (! in_array($row['alpha'], $used)) {
$used[] = $row['alpha'];
}
}
foreach ($letters as $letter) {
$class = '';
if ($letter == 'Z' && $az == $letter) {
$class = "class='last active'";
}
elseif ($letter == 'Z') {
$class = "class='last'";
}
elseif ($az == $letter) {
$class="class='active'";
}
if (in_array($letter, $used)) {
$alphanav .= "$letter\n";
}
else {
$alphanav .= "$letter\n";
}
}
if ($az == 'ALL') {
$alphanav .= "ALL\n";
}
else {
$alphanav .= "ALL\n";
}
$alphanav = "
$alphanav
\n\n";
// Append $az to the sql 'where' clause.
$where = '';
if ($az !== 'ALL' && $user['level'] < 3) {
$where = "where alpha='$az' and status='1'";
}
elseif ($az !== 'ALL' && $user['level'] > 2) {
$where = "where alpha='$az'";
}
elseif ($user['level'] < 3) {
$where = "where status='1'";
}
else {
$where = '';
}
$list = '';
$comps = array();
foreach($db->query("SELECT id,cname,status FROM companies $where order by cname")->fetchAll(PDO::FETCH_ASSOC) as $row) {
$comps[$row['id']] = $row['cname'];
$status[$row['id']] = $row['status'];
}
$numcomps = count($comps);
$onehalf = ceil($numcomps/2);
$cnt = 1;
$list = "\n
\n";
foreach ($comps as $key => $val) {
$style = '';
if ($status[$key] == '0') {
$style = 'disabled';
}
$list .= "
\n";
if ($numcomps > 5 && $cnt == $onehalf) {
$list .= "
\n
\n";
}
$cnt++;
}
$list .= "
\n
\n
\n";
$word = 'companies';
if ($numcomps == 1) {
$word = 'company';
}
$alphatitle = "$az $numcomps $word
\n";
$page['meta_title'] = $page['page_title'] = "A-Z List";
$page['content'] = $alphanav . $alphatitle . $list;
show_page($page);
exit;
?>