CREATE TABLE updates (updateid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, -> dateadded INT, //Unix Time Stamp. -> body BLOB, -> author CHAR(100));*/ include("hkf.php"); head("Last Update", "main"); $QUERY="SELECT * FROM updates ORDER BY dateadded DESC"; $QUERYRESULT=mysql_query($QUERY); print("\n

Latest Updates

"); print("\n"); while($row = mysql_fetch_row($QUERYRESULT)) { static $rowColor; if($rowColor == "#949dca") { $rowColor = "#838cb9"; } else { $rowColor = "#949dca"; } $DATE=date("F d Y", $row[1]); print("\n"); print(""); } print("\n
$DATE$row[2]"); //print("
--$row[3]--
"); tail(); ?>