0) { $i=0; // Retreiving data and putting it in local variables for each row $reviewed_artnr=MYSQL_RESULT($result,$i,"reviewed_artnr"); $destination_name=MYSQL_RESULT($result,$i,"destination_name"); $destination_artnr=MYSQL_RESULT($result,$i,"destination_artnr"); $rating=MYSQL_RESULT($result,$i,"rating"); $review_title=MYSQL_RESULT($result,$i,"review_title"); $review=MYSQL_RESULT($result,$i,"review"); $reviewer_name=MYSQL_RESULT($result,$i,"reviewer_name"); $reviewer_location=MYSQL_RESULT($result,$i,"reviewer_location"); $help_yes=MYSQL_RESULT($result,$i,"help_yes"); $help_no=MYSQL_RESULT($result,$i,"help_no"); $year_added=MYSQL_RESULT($result,$i,"year_added"); $month_added=MYSQL_RESULT($result,$i,"month_added"); $day_added=MYSQL_RESULT($result,$i,"day_added"); $sub_file_name=MYSQL_RESULT($result,$i,"sub_file_name"); $reviewed_artnr = stripslashes($reviewed_artnr); $destination_name = stripslashes($destination_name); $destination_artnr = stripslashes($destination_artnr); $rating = stripslashes($rating); $review_title = stripslashes($review_title); $review = stripslashes($review); $reviewer_name = stripslashes($reviewer_name); $reviewer_location = stripslashes($reviewer_location); $help_yes = stripslashes($help_yes); $help_no = stripslashes($help_no); $year_added = stripslashes($year_added); $month_added = stripslashes($month_added); $thisDay_added = stripslashes($thisDay_added); $thisShow_review = stripslashes($thisShow_review); //Create File Names require_once("$DOCUMENT_ROOT/masteradmin/create/forceFilename.php"); //to this comment $file_name = "$destination_name"; $file_name = forceFilename($file_name); $return_file_name = "/community/view_where/$file_name$destination_artnr.html"; $new_file_name = "/community/view_where/comments/$file_name$reviewed_artnr.html"; //to the destination page //Get ARTNR for the orignial destination $querysearch = "select * from SUGGEST_PLACE_VISIT where PLACE = '$destination_name'"; $resultsearch = MYSQL_QUERY($querysearch); $ARTNR=MYSQL_RESULT($resultsearch,$i,"ARTNR"); // $destination_file_name = "$destination_name"; $destination_file_name = forceFilename($destination_file_name); $destination_file_name = "/community/view_where/$file_name$ARTNR.html"; //Clean up the review $review_display = nl2br($review); $review_display = stripslashes($review_display); $review_display = str_replace("$search_term", "$search_term", "$review_display"); // $review_title = str_replace("$search_term", "$search_term", "$review_title"); if ($month_added == "1") { $month = "Jan"; $month_long = "January"; } if ($month_added == "2") { $month = "Feb"; $month_long = "February"; } if ($month_added == "3") { $month = "Mar"; $month_long = "March"; } if ($month_added == "4") { $month = "Apr"; $month_long = "April"; } if ($month_added == "5") { $month = "May"; $month_long = "May"; } if ($month_added == "6") { $month = "Jun"; $month_long = "June"; } if ($month_added == "7") { $month = "Jul"; $month_long = "July"; } if ($month_added == "8") { $month = "Aug"; $month_long = "August"; } if ($month_added == "9") { $month = "Sep"; $month_long = "September"; } if ($month_added == "10") { $month = "Oct"; $month_long = "Oct"; } if ($month_added == "11") { $month = "Nov"; $month_long = "November"; } if ($month_added == "12") { $month = "Dec"; $month_long = "December"; } //Convert Rating from numbers to Names if ($rating == "1") { $rating_discription = "Unacceptable"; } if ($rating == "2") { $rating_discription = "Acceptable"; } if ($rating == "3") { $rating_discription = "Average"; } if ($rating == "4") { $rating_discription = "Above Average"; } if ($rating == "5") { $rating_discription = "Oustanding"; } //Get the Review Total $help_total = ($help_yes + $help_no); // $reviewed_artnr = stripslashes($reviewed_artnr); $destination_name = stripslashes($destination_name); $destination_artnr = stripslashes($destination_artnr); $rating = stripslashes($rating); $review_title = stripslashes($review_title); $review = stripslashes($review); $review_display = preg_replace("#([\n> ^])([a-z]+?)://([^,<> \n\r]+)#i", "\\1\\2://\\3", $review_display); $reviewer_name = stripslashes($reviewer_name); $reviewer_location = stripslashes($reviewer_location); $help_yes = stripslashes($help_yes); $help_no = stripslashes($help_no); $year_added = stripslashes($year_added); $month_added = stripslashes($month_added); $thisDay_added = stripslashes($thisDay_added); $thisShow_review = stripslashes($thisShow_review); include("$DOCUMENT_ROOT/$SiteStyle/inc/header.inc.php"); ?>

Visitor Review for :

">
of people found the following comments helpful:
Date: ; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;"> ,
Reviewer: ; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;"> from .
Review Title:: ; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;"> .
Rating: ; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;"> (or ).
Review:
; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;">

Was this review helpful to you?  
"> "> "> "> "> ">
"> "> "> "> "> ">

Would you like to?: