<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