Illinois Marching Online News Archives
"; echo "
Date | "; echo "Article | "; echo "
$date | "; echo "$title |
require('wordpress_connection.inc.php');
function switchOrder($dir) {
if ($dir == "ASC") return "DESC";
else return "ASC";
}
if (isset($_REQUEST['col'])) {
$column = $_REQUEST['col'];
} else {
$column = "post_date";
}
if (isset($_REQUEST['dir'])) {
$dir = $_REQUEST['dir'];
} else {
$dir = "ASC";
}
if ($column == "post_date") {
$datelink = "archive.php?col=post_date&dir=".switchOrder($dir);
$titlelink = "archive.php?col=post_title&dir=ASC";
} else {
$datelink = "archive.php?col=post_date&dir=ASC";
$titlelink = "archive.php?col=post_title&dir=".switchOrder($dir);
}
$query = "SELECT ID, post_title, post_date FROM wp_posts WHERE post_status = 'publish' ORDER BY $column $dir";
$result = mysql_query($query);
echo "
Illinois Marching Online News Archives"; echo "
|