function ShowMenuItems($id) { global $db; $sql = "SELECT id, name, position, parent_id FROM menus WHERE parent_id='" . $id . "' ORDER by position"; //$columns['id'] = new Column_Number('ID', 0); $columns['name'] = new Column('Название'); $columns['position'] = new Column_Number('Позиция', 0); if ($id != 0) { $columns['back'] = new Column_Custom('Назад', '<input type="button" value="<" onClick="GoURL(\'?id=' . GetParentID($id) . '\')" />'); } $columns['more'] = new Column_UserFunc('Далее', 'GetChildIDButton', array('id')); // $columns['more'] = new Column_Button('Далее', '', 'id', '>>>'); $table = new Table($db, 'menu_edit', $sql, $columns); $table->Show_PageSwitch(false); $table->Show(); }
function GetObject($overhead_id, $type) { $data = ''; if ($type == 6) { $req = mysql_query("SELECT `id`, `name`\n\t\t\t\t\t\t\tFROM `object`\n\t\t\t\t\t\t\tWHERE `type` = 2 || `type` = 6"); // <<<<---------------------Type!!! if (!empty($overhead_id)) { $par_id = GetParentID($overhead_id); $obj = mysql_fetch_assoc(mysql_query("SELECT `object_id`\r\n\t\t\t\t\t\t\t\t\t\t\t\t FROM `reserve`\r\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE `overhead_id` = {$par_id}\r\n\t\t\t\t\t\t\t\t\t\t\t\t GROUP BY `overhead_id`")); } } else { $req = mysql_query("SELECT `id`, `name`\r\n\t\t\t\t\t\t\tFROM `object`\r\n\t\t\t\t\t\t\tWHERE `type` = 2 || `type` = 6"); // <<<<---------------------Type!!! if (!empty($overhead_id)) { $obj = mysql_fetch_assoc(mysql_query("SELECT `object_id`\r\n\t\t\t\t\t\t\t\t\t\t\t\t FROM `reserve`\r\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE `overhead_id` = {$overhead_id}\r\n\t\t\t\t\t\t\t\t\t\t\t\t GROUP BY `overhead_id`")); } } while ($res = mysql_fetch_assoc($req)) { if ($res['id'] == $obj['object_id']) { $data .= '<option value="' . $res['id'] . '" selected="selected">' . $res['name'] . '</option>'; } else { $data .= '<option value="' . $res['id'] . '">' . $res['name'] . '</option>'; } } return $data; }