heggie is gay

<?php

//assign PHP variables for connection code
$servername="localhost";
$username="root";
$password="";
$database="wildscottrust";

//connect to the database server
$link=mysql_connect($servername,$username,$password) ;
if(! $link)
	{
	die('Connection Failed'.mysql_error());
	}

//Select Wild Scot Trust database
mysql_select_db($database,$link) ;

//Using GET assign PHP details
$Name = $_GET['AnimalName'] ;
$category = $_GET['Category'] ;

If ($Name == ""){
	If ($category == "No Category"){
	echo "You did not enter any details, please return to home page";
	}
}


	If ($category =="No Category"){
		//Create PHP to store SQL query
		$query = "SELECT AnimalName, Category, BestPlaceToSee FROM animal WHERE AnimalName= '$Name'" ;}
	else {
		$query = "SELECT AnimalName, Category, BestPlaceToSee FROM animal WHERE Category= '$category'" ;
		}
	//Execute query
	$rows = mysql_query($query) or die(mysql_error());

	//Check that the query has returned at least one result
	if (mysql_num_rows($rows)==0)
		{
		echo "Sadly, the query has no animal details to return for your search";
		//display error message
		}
	else
		{
		//display matching animal details in table
		//first row of table contains headings

		echo '<table border="1" align="center"><tr><th>Animal Name</th><th>Category</th><th>Best Place To See</th>';
		while($Name = mysql_fetch_array($rows))
		//display each record returned by the query
			{
		echo '<tr><td>'.$Name['AnimalName'].'</td><td>'.$Name['Category'].'</td><td>'.$Name['BestPlaceToSee'].'</td></tr>';
			}
		echo"</table>";
		}


//close server connection
mysql_close($link);

//exit PHP
?>