0) { while ($row = db_fetch_assoc($homePages)) { $rnum = $row['record_num']; $title = $row['content_id']; $link = $row['page_link']; if (strlen($link) > 0) { if (!$list_started) echo("

\n"); $list_started = true; writeLog(" - $title"); echo("
• $title
\n"); } else { if (!$list_started) echo("
\n"); $list_started = true; writeLog(" - $title"); echo("
• $title
\n"); } } } // Check if there are tabs defined if (db_tableExists("content_tabs")) { $query = "SELECT count(*) FROM content_tabs WHERE school_num = $school_num $vwhere ORDER BY sequence"; writeLog($query); $numTabs = db_getVal($query); writeLog("numTabs: $numTabs"); // Get any additional pages if ($numTabs == 0 || $school_record['implement_page_tabs'] == 'N') { $query = "SELECT * FROM formatted_content WHERE school_num = $school_num AND content_type = 'A' AND tab_num != 0 $pwhere ORDER BY sequence"; writeLog($query); $results = db_query($query); if (db_num_rows($results)) { if (!$list_started) echo("
\n"); $list_started = true; writeLog(" - ".$school_record['additional_pages_title']); echo("
• " . $school_record['additional_pages_title'] . "\n"); echo("
  \n"); while ($row = db_fetch_assoc($results)) { $rnum = $row['record_num']; $title = $row['content_id']; $link = $row['page_link']; if (strlen($link) > 0) { echo("
  • $title
  \n"); } else { echo("
  • $title
  \n"); } } echo("
  \n"); echo("
\n"); } } else { if (!$list_started) echo("
\n"); $list_started = true; // Get tabs $query = "SELECT * FROM content_tabs WHERE school_num = $school_num $vwhere ORDER BY sequence"; writeLog($query); $tabs = db_query($query); while ($row = db_fetch_assoc($tabs)) { $tab_title = $row['tab_title']; $tab_num = $row['record_num']; $pages = db_query("SELECT * FROM formatted_content WHERE school_num = $school_num AND content_type = 'A' AND tab_num = $tab_num $pwhere ORDER BY sequence"); if (db_num_rows($pages)) { echo("
• $tab_title\n"); echo("
  \n"); while ($row = db_fetch_assoc($pages)) { $rnum = $row['record_num']; $title = $row['content_id']; $link = $row['page_link']; if (strlen($link) > 0) { echo("
  • $title
  \n"); } else { echo("
  • $title
  \n"); } } echo("
  \n"); echo("
\n"); } } } } ?>