// Connect to hcometz database and retrieve data
$username="root";
$password="alcatraz5757";
$database="hcometz";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT category FROM tb_categories where position > 0 order by position";
$result=mysql_query($query);
$num=mysql_numrows($result);
$query2="SELECT category FROM tb_categories where subcategory = 1 order by subcategory";
$result2=mysql_query($query2);
$num2=mysql_numrows($result2);
$query3="SELECT category FROM tb_categories where subcategory = 3 order by subcategory";
$result3=mysql_query($query3);
$num3=mysql_numrows($result3);
#$query4="SELECT [date] FROM tb_inventory order by [date]";
$query4="SELECT date FROM tb_inventory order by date desc limit 1";
$result4=mysql_query($query4);
$num4=mysql_numrows($result4);
$query5="SELECT * FROM tb_links order by position";
$result5=mysql_query($query5);
$num5=mysql_numrows($result5);
mysql_close();
//Get today's date for Copyrite
$today = getdate();
$year = $today['year'];
?>
Stuff for Sale
Home
//Category links from database
$i = 1;
while (($i - 1) < $num) {
$category=mysql_result($result,($i - 1),"category");
echo ''. $category .' ';
$i++;
}
?>
Links
/*
//Sub category links from database
$category_info = pg_query($conn, "select category from tb_categories where subcategory = 2 order by subcategory;");
while ($info_arr2 = pg_fetch_array($category_info)){
echo ''.$info_arr2['category'].'';
}*/
?>
Crafts
/*
//Sub category links from database
$category_info = pg_query($conn, "select category from tb_categories where subcategory = 4 order by subcategory;");
while ($info_arr2 = pg_fetch_array($category_info)){
echo ''.$info_arr2['category'].'';
}*/
?>
Computer stuff
 HCometz
.com  
"Stuff for sale" - Links
//Site updated stuff
$testDate = strtotime("1/1/02");
$i = 0;
while ($i < $num4) {
$dbdate=mysql_result($result4,$i,"date");
if (strtotime($dbdate) > $testDate){
$testDate = strtotime($dbdate);
$i++;
}
}
$filename1 = 'index.php';
$filename2 = 'categories.php';
if ((file_exists($filename1)) and (file_exists($filename2))) {
if (filemtime($filename1) > $testDate) {
$testDate = filemtime($filename1);
}
if (filemtime($filename2) > $testDate) {
$testDate = filemtime($filename2);
}
}
echo "Site last updated: " . date ("F d Y", $testDate);
?>