"; echo "Golf Club Equipment Reviews @ golfgearreview.com"; echo ""; 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 **************** */ /***********************************/ $sql = "select * from golfreadrev where Posted='Y' and Flag='G' order by Date desc"; $poo = mysql_query($sql); $numresults = mysql_num_rows($poo); echo "
".$Category."
"; echo " "; echo "

Number of reviews found: ".$numresults."

"; /******************************************/ /* Display Results of Review Search Query */ /******************************************/ echo "
"; echo ""; echo ""; for ($i=0; $i<$numresults; $i++) { $row = mysql_fetch_array($poo); $bad = array("#", "$", ".", ",", "+", "=", "@", "!", "^", "&", "*", "(", ")", "_", " ", "-", "--", "---", "----", "-----"); $ID = $row['ID']; $cat = str_replace($bad, "-", strtolower($row['Category'])); $model = str_replace($bad, "-", strtolower($row['Model'])); $man = str_replace($bad, "-", strtolower($row['Manufacturer'])); echo ""; }; echo "
"; echo ""; echo htmlspecialchars( stripslashes($row["Manufacturer"])); echo " "; echo htmlspecialchars( stripslashes($row["Model"])); echo " "; echo htmlspecialchars( stripslashes($row["Category"])); echo ""; echo "
"; echo "

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