Kodeks wybierz kodeks"; $lookup_category_id = db_fill_array("select category_id, name from categories order by 2"); if(is_array($lookup_category_id)) { reset($lookup_category_id); while(list($key, $value) = each($lookup_category_id)) { if($key == $fldcategory_id) $option="$value"; else $option="$value"; echo $option; } } ?> Dział Ustawa Z dnia Opubl. Dz. U. Szukane wyrażenie query($sSQL . $sWhere); if($db->next_record()) { //------------------------------- // Print subcategories //------------------------------- do { $category_id = tohtml($db->f("category_id")); $category_name = tohtml($db->f("name")); //------------------------------- // Categories ShowCategory Event begin // Categories ShowCategory Event end //------------------------------- ?> next_record()); } //------------------------------- echo " ABC query($sSQL . $sWhere); $db->next_record(); $current_category = tohtml($db->f("name")); $sParCatID = tohtml($db->f("par_category_id")); //------------------------------- // Build Path //------------------------------- $sPath = ""; while($sParCatID != "") { $db->query($sSQL . " where category_id=" . $sParCatID); if($db->next_record()) { $category_name = tohtml($db->f("name")); $category_id = tohtml($db->f("category_id")); $sParCatID = tohtml($db->f("par_category_id")); $sPath="" . $category_name . " > " . $sPath; } else break; } echo " > ".$sPath; echo $current_category; $sWhere = " where par_category_id=" . $sCatID; } ?> "; //------------------------------- // Categories Show end //------------------------------- //------------------------------- // Categories Close Event begin // Categories Close Event end //------------------------------- } //=============================== // Display Menu Form //------------------------------- function RecentListings_show() { global $db; global $styles; $sFormTitle = "Ostatnio dodane"; //------------------------------- // RecentListings Open Event begin if(get_param("category_id") != "") $sWhere = "WHERE i.category_id = " . get_param("category_id") . " OR c.par_category_id = " . get_param("category_id"); // RecentListings Open Event end //------------------------------- //------------------------------- // Set URLs //------------------------------- $fldparent_cat = "Kodeks"; $fldustawa = "Ustawa"; $fldopublikowana = "Opubl."; $flddz_u = "Dz. U."; $fldkodeks = "Kodeks"; //------------------------------- // RecentListings Show begin //------------------------------- //------------------------------- // RecentListings BeforeShow Event begin // RecentListings BeforeShow Event end //------------------------------- //------------------------------- // Show fields //------------------------------- ?>