
include 'connect.inc';
$wh = $_GET['wh'];
if ($wh == "") {
$query = "SELECT * FROM news WHERE archive = 0 ORDER BY artdate DESC LIMIT 1";
} else {
$query = "SELECT * FROM news WHERE id = $wh";
}
$result = mysql_query($query) or die("Query failed");
$line = mysql_fetch_row($result);
$wh = $line[0];
$title = $line[1];
$artdate = $line[2];
$byline = $line[3];
$source = $line[4];
$content = $line[5];
$archive = $line[6];
?>
echo $title; ?>
echo ($byline == "" ? "" : "$byline ");
echo ($source == "" ? "" : "$source, ");
$fdate = explode("-",$artdate);
echo date("F j, Y", mktime(0, 0, 0, $fdate[1], $fdate[2], $fdate[0])); ?>
if ($archive == 0) { ?>
 |
 |
$query = "SELECT * FROM news WHERE archive = 0 ORDER BY artdate DESC LIMIT 8";
$result = mysql_query($query) or die("Query failed");
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$id = $line["id"];
$title = $line["title"];
if ($wh != $id) {
print "$title
\n";
} else {
print "$title
\n";
}
}
?>
Archive > |
 |
}
mysql_close($link);
print $content;
if ($archive == 1) {
print "\n < Back to Archive";
}
?>
|