youtube.com/chiefsaffinity <-- sub4sub

<html>

<head>
<title>Wild Scot Trust Search Results</title>

<link rel="stylesheet" type="text/css" href="Wild Scot Trust Style.css">
</head>

<body>
<h1>Wild Scot Trust Search Results</h1>

<p> <img src="trust_logo.jpg" alt="Wild Scot Trust Logo" align="middle" width="150" height="150"> </p>

<br>
<br>

<?php

$servername="localhost";
$username="root";
$password="";
$database="wildscottrust";
$link = mysql_connect($servername,$username,$password);

mysql_select_db($database,$link) or die("Connection with database failed!");

$searchCategory=$_GET['Category'];
$searchName=$_GET['Animal'];

If ($searchName == "" && $searchCategory == "") {  //Check that a search criteria has been entered
	echo "You must enter a search criteria";}
else {

If ($searchName !== "") {
	$queryString=("SELECT AnimalName,Category,BestPlaceToSee FROM animal WHERE AnimalName = '$searchName'");}
else {
	$queryString=("SELECT AnimalName,Category,BestPlaceToSee FROM animal WHERE Category = '$searchCategory'");}

 $qry_result = mysql_query($queryString) or die(mysql_error());

 if (mysql_num_rows($qry_result)==0){
	echo "No animal with that name in the database";}
else{
	echo '<table border="1"><tr><th>Animal Name</th><th>Category</th><th>Best Place To See</th></tr>';
	while($row = mysql_fetch_array($qry_result)) {  //Repeat for all rows returned
		echo '<tr><td>'.$row['AnimalName'].'</td><td>'.$row['Category'].'</td><td>'.$row['BestPlaceToSee'].'</td></tr>';}
  }
 }

 ?>


<br>
 <p><a href="Wild Scot Trust.html">Return to Home Page</a></p>

</body>

</html>