require("config.inc"); require("languages.lib"); $pagetitle = $_glossary[$la]; $icon = "glossar"; $la = mysql_escape_string($_REQUEST["la"]); $letter = mysql_escape_string(substr($_REQUEST["letter"],0,1)); include("header.inc"); // if (($letter == "") && ($la != "ru")) { for ($i = 0; $i < 26; $i++) { $c = chr(65+$i); echo "$c"; echo " "; } // include("footer.inc"); // exit; // } ?>
$cid = mysql_connect($dbhost,$dbuser,$dbpasswd);
mysql_selectdb($dbname);
$la = mysql_escape_string($_REQUEST["la"]);
$letter = mysql_escape_string($_REQUEST["letter"]);
$q = "SELECT glossarid,keyword FROM glossar WHERE sprache='$la' AND keyword LIKE '$letter%' ORDER BY keyword";
$rg = mysql_query($q, $cid);
if ((mysql_num_rows($rg) == 0) && ($la != "en")) {
mysql_free_result($rg);
$q = "SELECT glossarid,keyword FROM glossar WHERE sprache='en' ORDER BY keyword";
$rg = mysql_query($q, $cid);
}
if (mysql_num_rows($rg) == 0) {
echo "$_noentry[$la]\n";
} else {
while ($row = mysql_fetch_object($rg)) {
$glossarid = $row->glossarid;
$keyword = $row->keyword;
echo "$keyword \n"; } mysql_free_result($rg); } mysql_close($cid); ?> |