Added season information to archives

1 files changed, 34 insertions, 0 deletions

@@ -0,0 +1,34 @@
+<?php
+
+if (is_numeric($_GET['season']))
+{
+        $getseason = "SELECT * FROM seasons WHERE season_id = " . $_GET['season'];
+        $getseason2 = mysql_query($getseason);
+        $getseason3 = mysql_fetch_array($getseason2);
+}
+
+if (isset($getseason3) && ($getseason3['season_id'] == $_GET['season']))
+{
+
+?>
+                        <H1>Archive for Season <?php echo($_GET['season']); ?></H1>
+
+                        <UL ID="archive">
+<?php
+
+$getcomics = "SELECT * FROM comics WHERE status = \"publish\" AND comic_id >= " . $getseason3['first_comic_id'] . " AND comic_id <= " . $getseason3['last_comic_id'] . " ORDER BY comic_id ASC";
+$getcomics2 = mysql_query($getcomics);
+while ($getcomics3 = mysql_fetch_array($getcomics2))
+{
+?>                              <LI><A HREF="/comic<?php echo($getcomics3['comic_id']); ?>.htm"><?php echo($getcomics3['title']); ?></A></LI>
+<?php
+}
+
+?>                      </UL>
+<?php
+
+} else {
+        include('pages/comic.php');
+}
+
+?>