<?php
	$titleanddate = "UPC - Tech Blog Article Archive";
	$keywords ="article archive, archive, tech archive, tech,blog,software,programming,gadgets,Internet,electronics,computer,hardware,web,design";

	include "header.inc";
?>
				<div id="content">
<?php
$db = mysql_connect("mysql102.mysite4now.com", "kevin", "razorpeppe");
mysql_select_db("UPC",$db);
$result = mysql_query("SELECT * FROM entry ORDER BY entrynum DESC",$db);
?>

<p style="font-size:small; text-align:center">
<b><u>All Past Posts:</u></b>
</p>
<br />
<?php

for ($i = 0; $i < 15; $i++) {
	$myrow = mysql_fetch_row($result);
	$filename = $myrow[1];
	$title = $myrow[2];
	$title = truncate($title, 80);
	$timestamp = $myrow[3];
		$timearray = explode(" ", $timestamp);
		$timestamp1 = $timearray[0];

	echo '<DIV style="text-align:center">';
	echo '<p style="font-size:small"><a href="http://www.upcsite.net/content/', $filename, '">', $title, '</a>';
	echo '<i> (', $timestamp1, ')</i></p>';
	echo '</DIV>';
}

echo '<BR />';
include "banneradcode.inc";

for ($i = 0; $i < 15; $i++) {
	$myrow = mysql_fetch_row($result);
	$filename = $myrow[1];
	$title = $myrow[2];
	$title = truncate($title, 80);
	$timestamp = $myrow[3];
		$timearray = explode(" ", $timestamp);
		$timestamp1 = $timearray[0];

	echo '<DIV style="text-align:center">';
	echo '<p style="font-size:small"><a href="http://www.upcsite.net/content/', $filename, '">', $title, '</a>';
	echo '<i> (', $timestamp1, ')</i></p>';
	echo '</DIV>';
}

echo '<BR />';
include "banneradcode.inc";

while ($myrow = mysql_fetch_row($result)) {
	
	$filename = $myrow[1];
	$title = $myrow[2];
	$title = truncate($title, 80);
	$timestamp = $myrow[3];
		$timearray = explode(" ", $timestamp);
		$timestamp1 = $timearray[0];

	echo '<DIV style="text-align:center">';
	echo '<p style="font-size:small"><a href="http://www.upcsite.net/content/', $filename, '">', $title, '</a>';
	echo '<i> (', $timestamp1, ')</i></p>';
	echo '</DIV>';
}

?>
				</div>
<?php
	include "footer.inc";
?>

