summary refs log tree commit diff stats
path: root/pages/season.php
blob: 6b45a27f6ecc6570462386abc3b6058480150c8b (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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');
}

?>