<p>Language: <?php
echo TLang::getDropDownList($lang, "lang", '');
?>
</p>
<p>Part of speech: <?php
echo TPOS::getDropDownList($pos, "pos", '');
?>
</p>
<p><input type="submit" name="view_dict" value="view"></p>
</form>
<?php
if (isset($view_dict) && $view_dict) {
$query = "SELECT pw_reverse_dict.page_id, reverse_page_title FROM pw_reverse_dict";
if ($pos > 0 || $lang > 0) {
$query .= ", lang_pos WHERE lang_pos.page_id=pw_reverse_dict.page_id";
if (TPOS::isExist($pos)) {
$query .= " and pos_id=" . (int) $pos;
}
if (TLang::isExist($lang)) {
$query .= " and lang_id=" . (int) $lang;
}
$query .= " group by pw_reverse_dict.page_id";
}
$query .= " order by reverse_page_title LIMIT 0,{$limit}";
// $query = "SELECT id, page_title FROM page order by page_title LIMIT 0,100";
//print $query;
$res_page = $link_db->query_e($query, "Query failed in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
print "<div style=\"width:50%; text-align:right\">";
$count = 0;
while ($row = $res_page->fetch_object()) {
// meaning.wiki_text_id>0 === words with non-empty definitions
