Posts: 803 Location: Dresden
Thu 14 Feb, 2008 23:32
Hi everybody,
I try to port a script into my Icy Phoenix and now i need your help.
The script uses other sql statements, and this is my problem. this is the original sql statement:
- $sections_ref = dbQuery("SELECT * FROM `{$cfg['db_table_prefix']}sections` WHERE `deleted` = 0 ORDER BY `name` ASC");
- while ($sections_row = dbFetch($sections_ref))
- {
- $seasons_ref = dbQuery("SELECT * FROM `{$cfg['db_table_prefix']}seasons` " .
- "WHERE `id_section` = {$sections_row['id']} AND `deleted` = 0 " .
- "ORDER BY `submitted` DESC");
- while ($seasons_row = dbFetch($seasons_ref))
- {
- $main_tpl->set_var("I_ID_SEASON", $seasons_row['id']);
- $main_tpl->set_var("I_SECTION_NAME", $sections_row['name']);
- $main_tpl->set_var("I_SEASON_NAME", $seasons_row['name']);
- $main_tpl->parse("H_SEASON_DROPDOWN", "B_SEASON_DROPDOWN", true);
- }
- }
and this is what i have done yet
- $sql = "SELECT * FROM " . TOURNEY_SECTIONS_TABLE . "
- WHERE `deleted` = 0
- ORDER BY `name` ASC";
- $result = $db->sql_query($sql);
- $section_info = $db->sql_fetchrowset($result);
- for ($x = 0; $x < count($section_info); $x++)
- {
- $section_id = $section_info[$x]['name'];
- }
-
- $sql = "SELECT * FROM " . TOURNEY_SEASONS_TABLE . "
- WHERE `deleted` = 0
- ORDER BY `submitted` DESC";
- $result = $db->sql_query($sql);
- $season_info = $db->sql_fetchrowset($result);
- $season_select = '';
- $season_select .= '<form action="">';
- $season_select .= 'Select Season: <select name="season_id" size="1">';
- $season_select .= '<option value="0">-</option>';
- for ($x = 0; $x < count($season_info); $x++)
- {
- $season_select .= '<option value="' . $season_info[$x]['id'] . '">' . $section_info[$x]['name'] . ' ' . $season_info[$x]['name'] . '</option>';
- }
- $season_select .= '</select>';
- $season_select .= '<input type="submit" value="Go">';
- $season_select .= '</form>';
-
- $template->assign_vars(array(
- 'SEASON_SELECT' => $season_select,
- )
- );
the problem is, that my code, select all seasons, correct, but the section name is not shown by all created options.
can somebody help me with that?
