From eee98526c48b9154cd9e9bc8bc3e07769e6a39ea Mon Sep 17 00:00:00 2001
From: Star Rauchenberger <fefferburbia@gmail.com>
Date: Sun, 22 Feb 2009 13:15:37 -0500
Subject: Rewrote Pillowcase

NOTE: There is a new database schema now, so the database from the testing server has to be copied over to the production server, otherwise this code
will fail.
---
 pages/archive.php | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 pages/archive.php

(limited to 'pages/archive.php')

diff --git a/pages/archive.php b/pages/archive.php
new file mode 100644
index 0000000..c1cd8ab
--- /dev/null
+++ b/pages/archive.php
@@ -0,0 +1,14 @@
+			<H1>Archive</H1>
+
+			<UL ID="archive">
+<?php
+
+$getcomics = "SELECT * FROM comics WHERE status = \"publish\" ORDER BY comic_id ASC";
+$getcomics2 = mysql_query($getcomics);
+while ($getcomics3 = mysql_fetch_array($getcomics2))
+{
+?>				<LI><A HREF="/comic<?php echo($getcomics3['comic_id']); ?>.htm"><?php echo($getcomics3['title']); ?></A></LI>
+<?php
+}
+
+?>			</UL>
-- 
cgit 1.4.1