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 echo "$destination_name"; ?>:
">
echo "$help_yes"; ?> of echo "$help_total"; ?> people found the following comments helpful:
|
Date:
; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;">
echo "$month_long"; ?> echo "$day_added"; ?>, echo "$year_added"; ?>
|
Reviewer:
; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;">
echo "$reviewer_name"; ?> from echo "$reviewer_location"; ?>.
|
Review Title::
; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;">
echo "$review_title"; ?>.
|
Rating:
; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;">
echo "$rating"; ?> (or echo "$rating_discription"; ?>).
|
Review:
; font-size: 12px; font-style: italic; font-weight: 700; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;">
echo "$review_display"; ?>
Was this review helpful to you?
|
|
|
Would you like to?:
|
}//End elseif records
mysql_free_result($result);
//Include Site Wide Footer File
$Blog = "";
include("$DOCUMENT_ROOT/$SiteStyle/inc/footer.inc.php");
?>