On this webpage... http://journeys-intl.com/take_out/country.php?country=%zambia%
You will see the "more_info" link on the right of each trip. When you roll your mouse over that link you are supposed to see it say http://journeys-intl.com/take_out/more_info3.php?trip_id=%x% where x is the trip number in my database. Why isn't anything showing up!? Here is the code in the php script:
<head>
<title>Journeys Search Results</title>
</head>
<body>
<?
include ("http://journeys-intl.com/includes/header.html");
$db = mysql_connect
//Perform query depending on user's selection
$result = mysql_query("SELECT * FROM master_trips WHERE country LIKE '$country'");
//Output Table
//Give it style
if($myrow = mysql_fetch_array($result))
{
$num_results=mysql_num_rows($result);
echo "<strong>Number of trips found: </strong><big><strong><font color=#008000>$num_results</font></strong></big><br><br>";
echo "<strong><font size=2 face=arial><img src='http://journeys-intl.com/images/arrow.gif' border=0 alt=arrow.gif><a href='javascript: history.go(-1)'> Back</a></font></strong><br><br>";
do{
$trip_id=urlencode($myrow["trip_ID"]);
echo "<TABLE BGCOLOR=#003366 WIDTH=700 BORDER=1 CELLPADDING=4 CELLSPACING=1>";
echo "<tr>";
echo "<td bgcolor=#EEE8CD align=center><strong>JOURNEYS</strong></td>";
echo "<td bgcolor=#EEE8CD align=center><strong>Trip Name</strong></td>";
echo "<td bgcolor=#EEE8CD align=center><strong>Country</strong></td>";
echo "<td bgcolor=#EEE8CD align=center width=300><strong>Description</strong></td>";
echo "<td bgcolor=#EEE8CD align=center><strong>More Info</strong></td></tr>";
echo "<tr><td valign=top align=center bgcolor=#FFFFFF>";
echo "<img src=".$image_path."/".$myrow['icon']." width=80 height=90>";
echo "</td>";
echo "<td valign=top bgcolor=#FFFFFF width=80><strong>";
echo $myrow['trp_name'];
echo "</strong></td>";
echo "<td valign=top bgcolor=#FFFFFF>";
echo $myrow['country'];
echo "</td>";
echo "<td valign=top bgcolor=#FFFFFF>";
echo $myrow['description'];
echo "</td>";
echo "<td valign=middle align=center bgcolor=#D8D8D8 width=70><strong>";
echo "<a href='more_info3.php?trip_id=$trip_id'>More Info</a>";
echo "</strong></td></tr></table><br><br>";
}
while ($myrow=mysql_fetch_array($result));
}
else
{
echo "Sorry, no records were found.";
}
include ("http://journeys-intl.com/includes/footer2.html");
?>
</body>
