$dicts = array(); @($res = mysql_query("select * from dicts")); while (@($row = mysql_fetch_array($res))) { $dicts[$row['d_id']] = $row['d_name']; } asort($dicts); if (is_numeric($dict)) { $tab = new TABLE(); if (!is_numeric($offset) or $offset < 0) { $offset = 0; } if (!is_numeric($limit) or $limit < 1) { $limit = 20; } @($res = mysql_query("select count(*) as cnt from vocab where v_d_id={$dict}")); @($row = mysql_fetch_array($res)); $cnt = $row['cnt']; $tab->add_row(array(array('attr' => 'colspan=5', 'cont' => pnav($cnt, $offset, $limit, "?dict={$dict}&") . "<br><br>"))); @($res = mysql_query("select * from vocab where v_d_id={$dict} order by v_english limit {$offset},{$limit}")); while (@($row = mysql_fetch_array($res))) { $tab->add_row(array($row['v_english'], "<i>" . $row['v_latin'] . "</i>", $row['v_czech'], $row['v_slovak'], $row['v_german'])); } $page->add_to_middle($tab->prepare()); } else { $menu = new VMENU(); while (list($k, $v) = each($dicts)) { $menu->add_item($v, "?dict={$k}"); } $page->add_to_middle($menu->prepare()); } $page->display();