Unable to connect to the " .
"database server at this time." );
exit();
}
// Select the database
if (! @mysql_select_db("$DBname") ) {
echo( "Unable to locate the DataBase at this time.
" );
exit();
}
//Get Default Display
if (empty($article)) {
$article = "1";
}
else {
$article = "$article";
}
$result = mysql_query ("SELECT * FROM TRIP_SUMMARY
where artnr ='$article'
");
if ($myrow = mysql_fetch_array($result)) {
//Get journal page count
$result_count = mysql_query ("SELECT * FROM TRIP_SUMMARY");
$num_rows = mysql_num_rows($result_count);
//End Summary page count
do {
$artnr = $myrow['artnr'];
$ARRIVE_YEAR = $myrow['ARRIVE_YEAR'];
$ARRIVE_MONTH = $myrow['ARRIVE_MONTH'];
$ARRIVE_DAY = $myrow['ARRIVE_DAY'];
$DEPART_YEAR = $myrow['DEPART_YEAR'];
$DEPART_MONTH = $myrow['DEPART_MONTH'];
$DEPART_DAY = $myrow['DEPART_DAY'];
$COUNTDOWN = $myrow['COUNTDOWN'];
$HUB_LOCATION = $myrow['HUB_LOCATION'];
$STATE = $myrow['STATE'];
$CITY = $myrow['CITY'];
$ENTRY_TITLE = $myrow['ENTRY_TITLE'];
$DONE_WHEN = $myrow['DONE_WHEN'];
$DONE_RATING = $myrow['DONE_RATING'];
$POSTING = $myrow['POSTING'];
$KEYWORDS = $myrow['KEYWORDS'];
} while($myrow = mysql_fetch_array($result));
} else {print "Sorry, their name is not in the database!";}
$artnr = stripslashes($artnr);
$CITY = stripslashes($CITY);
$ENTRY_TITLE = stripslashes($ENTRY_TITLE);
$KEYWORDS = stripslashes($KEYWORDS);
$POSTING = nl2br($POSTING);
$POSTING = stripslashes($POSTING);
$combined_title = "$ptitle: $ENTRY_TITLE";
//Arrive
if ($ARRIVE_MONTH == "1") {
$ARRIVE_MONTH_SHORT = "Jan";
$ARRIVE_MONTH_LONG = "January";
}
if ($ARRIVE_MONTH == "2") {
$ARRIVE_MONTH_SHORT = "Feb";
$ARRIVE_MONTH_LONG = "February";
}
if ($ARRIVE_MONTH == "3") {
$ARRIVE_MONTH_SHORT = "Mar";
$ARRIVE_MONTH_LONG = "March";
}
if ($ARRIVE_MONTH == "4") {
$ARRIVE_MONTH_SHORT = "Apr";
$ARRIVE_MONTH_LONG = "April";
}
if ($ARRIVE_MONTH == "5") {
$ARRIVE_MONTH_SHORT = "May";
$ARRIVE_MONTH_LONG = "May";
}
if ($ARRIVE_MONTH == "6") {
$ARRIVE_MONTH_SHORT = "Jun";
$ARRIVE_MONTH_LONG = "June";
}
if ($ARRIVE_MONTH == "7") {
$ARRIVE_MONTH_SHORT = "Jul";
$ARRIVE_MONTH_LONG = "July";
}
if ($ARRIVE_MONTH == "8") {
$ARRIVE_MONTH_SHORT = "Aug";
$ARRIVE_MONTH_LONG = "August";
}
if ($ARRIVE_MONTH == "9") {
$ARRIVE_MONTH_SHORT = "Sep";
$ARRIVE_MONTH_LONG = "September";
}
if ($ARRIVE_MONTH == "10") {
$ARRIVE_MONTH_SHORT = "Oct";
$ARRIVE_MONTH_LONG = "Oct";
}
if ($ARRIVE_MONTH == "11") {
$ARRIVE_MONTH_SHORT = "Nov";
$ARRIVE_MONTH_LONG = "November";
}
if ($ARRIVE_MONTH == "12") {
$ARRIVE_MONTH_SHORT = "Dec";
$ARRIVE_MONTH_LONG = "December";
}
//Depart
if ($DEPART_MONTH == "1") {
$DEPART_MONTH_SHORT = "Jan";
$DEPART_MONTH_LONG = "January";
}
if ($DEPART_MONTH == "2") {
$DEPART_MONTH_SHORT = "Feb";
$DEPART_MONTH_LONG = "February";
}
if ($DEPART_MONTH == "3") {
$DEPART_MONTH_SHORT = "Mar";
$DEPART_MONTH_LONG = "March";
}
if ($DEPART_MONTH == "4") {
$DEPART_MONTH_SHORT = "Apr";
$DEPART_MONTH_LONG = "April";
}
if ($DEPART_MONTH == "5") {
$DEPART_MONTH_SHORT = "May";
$DEPART_MONTH_LONG = "May";
}
if ($DEPART_MONTH == "6") {
$DEPART_MONTH_SHORT = "Jun";
$DEPART_MONTH_LONG = "June";
}
if ($DEPART_MONTH == "7") {
$DEPART_MONTH_SHORT = "Jul";
$DEPART_MONTH_LONG = "July";
}
if ($DEPART_MONTH == "8") {
$DEPART_MONTH_SHORT = "Aug";
$DEPART_MONTH_LONG = "August";
}
if ($DEPART_MONTH == "9") {
$DEPART_MONTH_SHORT = "Sep";
$DEPART_MONTH_LONG = "September";
}
if ($DEPART_MONTH == "10") {
$DEPART_MONTH_SHORT = "Oct";
$DEPART_MONTH_LONG = "Oct";
}
if ($DEPART_MONTH == "11") {
$DEPART_MONTH_SHORT = "Nov";
$DEPART_MONTH_LONG = "November";
}
if ($DEPART_MONTH == "12") {
$DEPART_MONTH_SHORT = "Dec";
$DEPART_MONTH_LONG = "December";
}
$page_description = "The World's Only Real Traveling Webmasters Travel summary of $CITY, $STATE on $DAY $DEPART_MONTH_LONG $YEAR. $next_location_display_for_meta";
$number_display = "10";
$title_font_size ="-1";
$base_font = "-2";
include("$DOCUMENT_ROOT/$SiteStyle/inc/header.inc.php");
?>
|
Go back to the Previous Entry:";
}//End elseif index page
else {
echo "Go back to the Previous Entry:";
}//end else
?>
|
"$num_rows") {
echo"This is the last trip summary completed
Go back to the First Entry:.";
}
elseif ($next_artnr == "1") {
echo "Go back to the Next Entry:";
}//End elseif index page
else {
echo "Go to the Next Entry:";
}//end else
?>
|
">Adventure Day :
">Date Arrived:
">Date Departed:
">Hub Area:
">Actual Location: City : ">State :
">Summary Title :
">Summary :
Ray Plumlee's Rating : Stars out of 5.
|
Go back to the Previous Entry:";
}//End elseif index page
else {
echo "Go back to the Previous Entry:";
}//end else
?>
|
"$num_rows") {
echo"This is the last trip summary completed
Go back to the First Entry:.";
}
elseif ($next_artnr == "1") {
echo "Go back to the Next Entry:";
}//End elseif index page
else {
echo "Go to the Next Entry:";
}//end else
?>
|
">Keywords Used in This Entry :
|
|