"; echo ""; echo ""; echo htmlspecialchars( stripslashes($row["Manufacturer"])); echo " "; echo "Golf"; echo " "; echo htmlspecialchars( stripslashes($row["Category"])); echo ""; echo ""; echo ""; /* include top and left HTML */ include("home-top.html"); echo "

"; echo htmlspecialchars( stripslashes($row["Manufacturer"])); echo " "; echo "Golf"; echo " "; echo htmlspecialchars( stripslashes($row["Category"])); echo "

"; /* Loop through and display a selected review based on Manufacturer and Category */ for ($i=0; $i < $num_results; $i++) { echo "
"; echo ""; echo ""; echo "
"; echo htmlspecialchars( stripslashes($row["Manufacturer"])); echo " "; echo htmlspecialchars( stripslashes($row["Model"])); echo " "; echo htmlspecialchars( stripslashes($row["Category"])); echo "
"; echo htmlspecialchars( stripslashes($row["Summary"])); echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
Purchase:"; echo htmlspecialchars( stripslashes($row["Purchase"])); echo "
Likes:"; echo htmlspecialchars( stripslashes($row["Likes"])); echo "
Dislikes:"; echo htmlspecialchars( stripslashes($row["Dislikes"])); echo "
Quality:"; echo htmlspecialchars( stripslashes($row["Quality"])); echo "
Summary:"; echo htmlspecialchars( stripslashes($row["Summary"])); echo "
Rating:
Author:"; echo htmlspecialchars( stripslashes($row["Author"])); echo "
Date:"; echo htmlspecialchars( stripslashes($row["Date"])); echo "
"; echo "

"; $row = mysql_fetch_array($result); } echo ""; echo "
"; /* Display links to other interesting reviews */ echo "Other Reviews You May Find Interesting"; /***********************************/ /* Select Records **************** */ /***********************************/ $query = "select * from golfreadrev where Posted =\"Y\" and Flag =\"G\" or Flag =\"A\" order by Date desc limit 20"; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo " "; echo "

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

"; echo "
"; ?>