Hello everyon I really need some help when ever I click my refresh news archive link it wont rebuild the news page but it will append the $archiveend information.
Any help is appreciated.
$command=$HTTP_GET_VARS["command"];
//Generates news page archive.php
function news_archive_generator(){
//Database Variables for retreiving News Posts
$db_name = "diablo";
$table_name = "news";
$connection = mysql_connect("65.26.138.33", "KingWylim", "a071584a") or die(mysql_error());
$db = mysql_select_db($db_name, $connection) or die(mysql_error());
$sql = "
SELECT * FROM $table_name ORDER BY post_date desc
";
$result = mysql_query($sql, $connection) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$post_date = $row['post_date'];
$month = substr($post_date, 4, 2);
$year = substr($post_date, 0, 4);
$date_one = "$year$month";
}
$archive .= "<?\n";
$archive .= "require(\"top_layout.php\");\n";
$archive .= "if(\$selection==$date_one){\n";
$archive .= "?>\n";
$archive .= "<table border=1 width=\"100%\">\n";
$archive .= "<tr>\n";
$archive .= "<td width=\"10%\">Date</td>\n";
$archive .= "<td width=\"60%\">Subject</td>\n";
$archive .= "<td width=\"10%\">Username</td>\n";
$archive .= "</tr>\n";
$posts=0;
while($row = mysql_fetch_array($result)){
$userid = $row['userid'];
$subject = $row['subject'];
$post_date = $row['post_date'];
$day = substr($post_date, 6, 2);
$month = substr($post_date, 4, 2);
$year = substr($post_date, 0, 4);
$body = $row['body'];
if($posts<5){
$no_archive .= "<?\n";
$no_archive .= "require(\"top_layout.php\");\n";
$no_archive .= "?>\n";
$no_archive .= "<center>Sorry there isn't any archived news currently.</center>\n";
$no_archive .= "<?\n";
$no_archive .= "if(\$selection==$date_one){\n";
$no_archive .= "?>\n";
$no_archive .= "<table border=1 width=\"100%\">\n";
$no_archive .= "<tr>\n";
$no_archive .= "<td width=\"10%\">Date</td>\n";
$no_archive .= "<td width=\"60%\">Subject</td>\n";
$no_archive .= "<td width=\"10%\">Username</td>\n";
$no_archive .= "</tr>\n";
$no_archive .= "<tr>\n";
$no_archive .= "</tr>\n";
$filename = "newsarchive.php";
$news_archive = fopen($filename, "w") or die(mysql_error());
fwrite($news_archive, $no_archive) or die(mysql_error());
fclose($news_archive);
} else {
$archive .= "<tr>\n";
$archive .= "<td><div align=\"left\">$month, $day $year</div></td>\n";
$archive .= "<td><a href=\"$year/$month.php#$subject\">$subject</a></td>\n";
$archive .= "<td>$username</td>\n";
$archive .= "</tr>\n";
$filename = "newsarchive.php";
$news_archive = fopen($filename, "w") or die(mysql_error());
fwrite($news_archive, $archive) or die(mysql_error());
fclose($news_archive);
}
$posts++;
}
$archiveend .= "</table>\n";
$archiveend .= "<?\n";
$archiveend .= "} else {\n";
$archiveend .= "?>\n";
for($i=0;$i<=mysql_numrows($result[3]);$i++){
$archiveend .= "<center><a href=newsarchive.php?selection=$date_one>$year $month</a></center>\n";
}
$archiveend .= "<?\n";
$archiveend .= "}\n";
$archiveend .= "require(\"bottom_layout.php\");\n";
$archiveend .= "?>\n";
$filename = "newsarchive.php";
$news_archive = fopen($filename, "a") or die(mysql_error());
fwrite($news_archive, $archiveend) or die(mysql_error());
fclose($news_archive);
}
if($command==refresh){
news_archive_generator();
}
