<?PHP
//Connect To Database
$hostname='localhost';
$username='root';
$password='root';
$dbname='2012Programs';

mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');

mysql_select_db($dbname);

$countryId = $_GET['c'];

$sql = "SELECT programId, programCode, programName, programLink, programPrice, programInternationalAir, programInternalAir, programFee, programFeeDesc, programDuration, programDepartureLocation, programMinAge, programMaxAge, programServiceHours FROM programs WHERE countryId = " . $countryId . " ORDER by programName";

$result = mysql_query($sql)
	or die("<hr />" . mysql_error() . "<br />$sql<hr />");

echo '<table>' . "\r\n";
?>
<tr>
<td>ID</td>
<td>TRIP CODE</td>
<td>Program Name</td>
<td>WWW Link</td>
<td>Price</td>
<td>Internal Air</td>
<td>Extra Fee</td>
<td>Fee Description</td>
<td>Total Duration</td>
<td>Departure Location</td>
<td>Minimum Age</td>
<td>Maximum Age</td>
<td>Hours</td>
<td>Dates</td>
</tr>

<?
while ($row = mysql_fetch_assoc($result)) {
	echo "<pre>";
	print_r($row);
	echo "</pre>";

	$sessionSql = "SELECT startDate FROM sessions WHERE programId = " . $row['programId'] . " ORDER BY startDate";

	$sessionResult = mysql_query($sessionSql)
		or die("<hr />" . mysql_error() . "<br />$sql<hr />");

	while ($sessionRow = mysql_fetch_assoc($sessionResult)) {
		$sessions[] = date('F j', strtotime($sessionRow['startDate']));
	}

	$sessions = implode(", ", $sessions);

	echo '<tr>' . "\r\n";
	echo '<td>' . $row['programId'] . '</td>' . "\r\n";
	echo '<td>' . $row['programCode'] . '</td>' . "\r\n";
	echo '<td>' . $row['programName'] . '</td>' . "\r\n";
	echo '<td>' . $row['programLink'] . '</td>' . "\r\n";
	echo '<td>' . $row['programPrice'] . '</td>' . "\r\n";
	echo '<td>' . $row['programInternalAir'] . '</td>' . "\r\n";
	echo '<td>' . $row['programFee'] . '</td>' . "\r\n";
	echo '<td>' . $row['programFeeDesc'] . '</td>' . "\r\n";
	echo '<td>' . $row['programDuration'] . '</td>' . "\r\n";
	echo '<td>' . $row['programDepartureLocation'] . '</td>' . "\r\n";
	echo '<td>' . $row['programMinAge'] . '</td>' . "\r\n";
	echo '<td>' . $row['programMaxAge'] . '</td>' . "\r\n";
	echo '<td>' . $row['programServiceHours'] . '</td>' . "\r\n";
	echo '<td>' . $sessions . '</td>' . "\r\n";
	echo '</tr>' . "\r\n";
}
echo '</table>' . "\r\n";

mysql_close();

?>