summary refs log tree commit diff stats
path: root/pages/archive.php
diff options
context:
space:
mode:
Diffstat (limited to 'pages/archive.php')
-rwxr-xr-xpages/archive.php20
1 files changed, 8 insertions, 12 deletions
diff --git a/pages/archive.php b/pages/archive.php index c5f0f52..114062c 100755 --- a/pages/archive.php +++ b/pages/archive.php
@@ -10,25 +10,21 @@
10 10
11<?php 11<?php
12 12
13$getseasons = "SELECT * FROM seasons ORDER BY season_id ASC"; 13$getseasons = $mysql_conn->query("SELECT * FROM seasons ORDER BY season_id ASC");
14$getseasons2 = mysql_query($getseasons); 14foreach ($getseasons as $getseasons3)
15while ($getseasons3 = mysql_fetch_array($getseasons2))
16{ 15{
17 $getfc = "SELECT * FROM comics WHERE comic_id = " . $getseasons3['first_comic_id']; 16 $getfc = $mysql_conn->query("SELECT * FROM comics WHERE comic_id = " . $getseasons3['first_comic_id']);
18 $getfc2 = mysql_query($getfc); 17 $getfc3 = $getfc->fetch_assoc();
19 $getfc3 = mysql_fetch_array($getfc2);
20 18
21 if (!is_null($getseasons3['last_comic_id'])) 19 if (!is_null($getseasons3['last_comic_id']))
22 { 20 {
23 $getlc = "SELECT * FROM comics WHERE comic_id = " . $getseasons3['last_comic_id']; 21 $getlc = $mysql_conn->query("SELECT * FROM comics WHERE comic_id = " . $getseasons3['last_comic_id']);
24 $getlc2 = mysql_query($getlc); 22 $getlc3 = $getlc->fetch_assoc();
25 $getlc3 = mysql_fetch_array($getlc2);
26 23
27 $count = $getseasons3['last_comic_id'] - ($getseasons3['first_comic_id']-1); 24 $count = $getseasons3['last_comic_id'] - ($getseasons3['first_comic_id']-1);
28 } else { 25 } else {
29 $getcnt = "SELECT COUNT(*) FROM comics WHERE comic_id >= " . $getseasons3['first_comic_id']; 26 $getcnt = $mysql_conn->query("SELECT COUNT(*) FROM comics WHERE comic_id >= " . $getseasons3['first_comic_id']);
30 $getcnt2 = mysql_query($getcnt); 27 $getcnt3 = $getcnt->fetch_assoc();
31 $getcnt3 = mysql_fetch_array($getcnt2);
32 28
33 $count = $getcnt3[0]; 29 $count = $getcnt3[0];
34 } 30 }