need help with comic script

[the-alcove]

ok so heres what you need to know. My website is a webcomic site. You can find it at http://www.the-alcove.com
It's using the e-107 website system.
To upload comics and to archive them, i downloaded "comic archiver v2.5" as a php plugin for the site.
Here's the problem: If you check out the menu on the left side of the site, and click on new comic, you will see the newest one. But if you click on "first" or "previous" or anything else, you will still see the newest comic. My guess that there's an error in one line of the script. I was wondering if anyone here could please help me out here. Much appreciated.

Brian

The-alcove webcomic

[kidgeek_dfw]

I think you'll need to post some code here to debug...

comic=x seems to be functioning properly...

Maybe the variable is not being called correctly on image load...
Or maybe all the images are the same...

Hard to tell unless you post some code...

[the-alcove]

alrighty, well here's the comic.php code, which im pretty sure is the one thats causing the problem:

<?php
/
+---------------------------------------------------------------+
| e107 website system
| /comic_menu/comic.php
|
| ©Brian Arndt 2003-2004
| http://www.sorethumbz.com
| [e-mail]
|
| Released under the terms and conditions of the
| GNU General Public License (http://gnu.org).
+---------------------------------------------------------------+
/
require_once("../../class2.php");
require_once(HEADERF);
$text = "<center>";

//Define Date
$current_date = date("Ymd", time()+7200);

//Define Last Comic
$sql7 = new db;
$sql7 -> db_Select("comic_archive", "*", "WHERE post_date<='$current_date' ORDER BY number DESC LIMIT 0,1", $mode = "no_where");
$row7 = $sql7 -> db_Fetch();
extract($row7);
$lastcomic = $number;

// Latest Comic
if(isset($comic)) {
$sql4 = new db;
$sql4 -> db_Select("comic_archive", "*", " number = '$comic'");
$row4 = $sql4 -> db_Fetch();
extract($row4);
$comic_title = $title;
$new_comic = $file;

// Determine Comics Date
preg_match('/([0-9]{4})([0-9]{2})([0-9]{2})/', $post_date, $match);
$month = $match[2];
$day = $match[3];
$year = $match[1];
$comicdate = "$month/$day/$year";
}else{

$sql5 = new db;
$sql5 -> db_Select("comic_archive", "*", "WHERE post_date<='$current_date' ORDER BY number DESC LIMIT 0,1", $mode = "no_where");
$row5 = $sql5 -> db_Fetch();
extract($row5);
$new_comic = $file;
$comic_title = $title;
$comic = $number;

// Determine Comics Date
preg_match('/([0-9]{4})([0-9]{2})([0-9]{2})/', $post_date, $match);
$month = $match[2];
$day = $match[3];
$year = $match[1];
$comicdate = "$month/$day/$year";
}

//Comic Buttons

// Random
$sql = new db;
$sql -> db_Select("comic_archive", "number", "WHERE post_date<='$current_date' ORDER BY RAND() LIMIT 0,1", $mode = "no_where");
$row = $sql -> db_Fetch();
extract($row);
$rand = $number;
$random_comic = "<a href=\"comic.php?comic=$rand\"><img src=\"".e_PLUGIN."comic_menu/images/comic_random.gif\" border=\"0\" alt=\"Random\"></a>";

// Previous and First
if ($comic > 1) {
$sql = new db;
$sql -> db_Select("comic_archive", "*", "WHERE number <'$comic' ORDER BY number DESC LIMIT 0,1", $mode = "no_where");
$row = $sql -> db_Fetch();
extract($row);
$previous = $number;
$prev_comic = "<a href=\"comic.php?comic=$previous\"><img src=\"".e_PLUGIN."comic_menu/images/comic_prev.gif\" border=\"0\" alt=\"Previous\"></a>";
$first_comic = "<a href=\"comic.php?comic=1\"><img src=\"".e_PLUGIN."comic_menu/images/comic_first.gif\" border=\"0\" alt=\"First\"></a>";
}else{
$prev_comic = "";
$first_comic = "";
}

// Next and Last
if ($comic < $lastcomic) {
$sql = new db;
$sql -> db_Select("comic_archive", "*", "WHERE number >'$comic' ORDER BY number ASC LIMIT 0,1", $mode = "no_where");
$row = $sql -> db_Fetch();
extract($row);
$next = $number;
$next_comic = "<a href=\"comic.php?comic=$next\"><img src=\"".e_PLUGIN."comic_menu/images/comic_next.gif\" border=\"0\" alt=\"Next\"></a>";
$last_comic = "<a href=\"comic.php\"><img src=\"".e_PLUGIN."comic_menu/images/comic_last.gif\" border=\"0\" alt=\"Last\"></a>";
}else{
$next_comic = "";
$last_comic = "";
}

// Display Comic and Links
$text .= "<br><img src=\"".e_PLUGIN."comic_menu/comics/$new_comic\"><br><br>";
$text .= "$first_comic $prev_comic $random_comic $next_comic $last_comic<br> ";

$text .= "<table><tr><td valign='top' align='center' style=' text-align:center'>";

// VOTING
if(isset($vote)) {
$sql3 = new db;
$sql3 -> db_Select("comic_archive", "rating,votes", "number ='$comic'");
$row3 = $sql3 -> db_Fetch();
extract($row3);
$oldrating = $rating;
$oldvotes = $votes;
$newrating= $oldrating+$vote;
$newvotes = $oldvotes+1;
$sql = new db;
$sql -> db_Update("comic_archive", "votes='$newvotes', rating='$newrating' WHERE number='$comic' ");
}

$sql2 = new db;
$sql2 -> db_Select("comic_archive", "rating,votes", "number ='$comic'");
$row2 = $sql2 -> db_Fetch();
extract($row2);
$comicrating = $rating/$votes;
if($comicrating >= 4.50){
$ratingimg = "5.gif";
}elseif($comicrating >= 3.50){
$ratingimg = "4.gif";
}elseif($comicrating >= 2.50){
$ratingimg = "3.gif";
}elseif($comicrating >= 1.50){
$ratingimg = "2.gif";
}elseif($comicrating >= 0.50){
$ratingimg = "1.gif";
}else{
$ratingimg = "0.gif";
}
$text .="<img src=\"".e_PLUGIN."comic_menu/images/$ratingimg\" border=\"0\" alt=\"Comic Rating\"><br />($votes votes) ";
$text .="</td><td valign='top' align='top'>";
$text .= "<select name=\"menu2\" onChange=\"MM_jumpMenu('parent',this,0)\">
<OPTION value=\"\">Rate It</OPTION>
<OPTION value=\"comic.php?comic=$comic&vote=5\">5 - Awesome</OPTION>
<OPTION value=\"comic.php?comic=$comic&vote=4\">4 </OPTION>
<OPTION value=\"comic.php?comic=$comic&vote=3\">3 - Good</OPTION>
<OPTION value=\"comic.php?comic=$comic&vote=2\">2 </OPTION>
<OPTION value=\"comic.php?comic=$comic&vote=1\">1 - Poor</OPTION>
</SELECT>";

$text .="</td><td valign='top' align='top'>";

// ARCHIVE List
if ($comic == "archive"){

$sql7 = new db;
$sql7 -> db_Select("comic_archive", "*");
$i = 0;
$j = 0;
$k = 0;
$text .="<table><tr><td>";
while($row7 = $sql7 -> db_Fetch()){
$i++;
$j++;
$k++;

while ($i == 15) {

while ($j ==3) {

while ($k == 5) {

$text .= "[$number] <a href=\"comic.php?comic=$number\">$title</a> ";
}
}
}

}
$text .="</td></tr></table>";
$caption = "<b>$name</b>: Archive";
}else{
// Pulldown
$text .= "
<SCRIPT language=JavaScript>
function MM_jumpMenu(targ,selObj,restore){
eval(targ+\".location='\"+selObj.options[selObj.selectedIndex].value+\"'\");
if (restore) selObj.selectedIndex=0;
}
</script>";
$text .= "
<select name=\"menu1\" onChange=\"MM_jumpMenu('parent',this,0)\">
<OPTION value=\"\">Comic Archive...</OPTION><br> ";
$sql3 = new db;
$sql3 -> db_Select("comic_archive", "*", "WHERE post_date='0'|| post_date<='$current_date' ORDER BY number DESC", $mode = "no_where");
while($row3 = $sql3-> db_Fetch()){
extract($row3);
// Determine Comics Date
preg_match('/([0-9]{4})([0-9]{2})([0-9]{2})/', $post_date, $match);
$month = $match[2];
$day = $match[3];
$year = $match[1];
$comicdate2 = "$month/$day/$year";
$text .= "<OPTION value=\"comic.php?comic=$number\">$number. $title - $comicdate2</OPTION><br> ";
}
$text .= "</SELECT><br><br>";

$text .= "</tr></td></table>";

$caption = " #$comic. $comic_title - $comicdate";
}
$text .= "</center>";
$ns -> tablerender($caption, $text);
require_once(FOOTERF);
?>