"; echo ""; include("home-top.html"); /* Connect to ASN database */ $db = mysql_connect(":/usr/share/web/bereznay2/mysql/socket", "root", ""); mysql_select_db("asn",$db); if (!$db) { echo "Error: Could not connect to database. Please try again later."; exit; } /***********************************/ /* Select Records **************** */ /***********************************/ $query = "select * from golfarticles where Posted =\"Y\" and Flag =\"G\" order by Date desc"; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo " "; echo "

Number of articles found: ".$num_results."

"; /******************************************/ /* Display Results of Review Search Query */ /******************************************/ echo "
"; echo ""; echo ""; for ($i=0; $i <$num_results; $i++) { $row = mysql_fetch_array($result); echo ""; echo ""; echo htmlspecialchars( stripslashes($row["Date"])); echo " "; echo htmlspecialchars( stripslashes($row["Title"])); echo ""; echo ""; } echo "
"; echo "

"; include("home-right.html"); ?>