<?php
?>
<html>
<body>
<?php
//definimos variables
//This is only displayed if they have submitted the form
if ($searching =="yes") { echo "<h2>Results</h2><p>";
//If they did not enter a search term we give them an error
if ($find == "") { echo "<p>You forgot to enter a search term"; exit; }
// Otherwise we connect to our Database
// We preform a bit of filtering
//Now we search for our search term, in the field the user specified
$data = mysql_query("SELECT * FROM expediente WHERE sexo LIKE '%$find%' AND raza LIKE '%$field%' ");
//And we display the results
{
echo $result['dueno'];
echo "<br>";
echo $result['raza'];
echo "<br>";
echo $result['sexo'];
echo "<br>";
echo $result['telefono'];
echo "<br>";
}
//This counts the number or results - and if there wasn't any it gives them a little message explaining that
if(!mysql_num_rows($data)) { echo "Sorry, but we can not find an entry to match your query<br><br>"; }
//And we remind them what they searched for
echo "<br/>";
echo "<b>Searched For:</b> " .$find .$field; } ?>
<form name="search" method="post"
action="<?php echo $_SERVER['PHP_SELF']; ?>">Buscar: Macho<input
type="radio" name="find" value="Macho" /> Hembra<input type="radio"
name="find" value="Hembra" /> En <select size=1 name="field">
<option value="Airedale Terrier">Airedale Terrier</option>
<option value="Akita">Akita</option>
<option value="Akita americano">Akita americano</option>
<option value="Alaskan Malamute">Alaskan Malamute</option>
<option value="American pit bull terrier">American pit bull terrier</option>
<option value="American staffordshire terrier">American staffordshire
terrier</option>
<option value="Australian terrier">Australian terrier</option>
<option value="Basset Hound">Basset Hound</option>
<option value="Beagle">Beagle</option>
<option value="Bichon maltes">Bichon maltes</option>
<option value="Bloodhound">Bloodhound</option>
<option value="Border Collie">Border Collie</option>
<option value="Boston terrier">Boston terrier</option>
<option value="Bouvier des Flandres">Bouvier des Flandres</option>
<option value="Boxer">Boxer</option>
<option value="Bull terrier">Bull terrier</option>
<option value="Bulldog Ingles">Bulldog Ingles</option>
<option value="Bulldog americano">Bulldog americano</option>
<option value="Bulldog frances">Bulldog frances</option>
<option value="Bullmastiff">Bullmastiff</option>
<option value="Chihuahua">Chihuahua</option>
<option value="Chow Chow">Chow Chow</option>
<option value="Cocker Spaniel Americano">Cocker Spaniel Americano</option>
<option value="Cocker Spaniel Inglés">Cocker Spaniel Inglés</option>
<option value="Dachshund (Salchicha)">Dachshund (Salchicha)</option>
<option value="Dalmata">Dalmata</option>
<option value="Dobermann">Dobermann</option>
<option value="Dogo Argentino">Dogo Argentino</option>
<option value="Dogo de Burdeos">Dogo de Burdeos</option>
<option value="Fila Brasileiro">Fila Brasileiro</option>
<option value="Fox terrier">Fox terrier</option>
<option value="Galgo">Galgo</option>
<option value="Gigate de los Pirineos">Gigante de los Pirineos</option>
<option value="Golden Retriever">Golden Retriever</option>
<option value="Gran Danés">Gran Danés</option>
<option value="Husky Siberiano">Husky Siberiano</option>
<option value="Lhasa apso">Lhasa apso</option>
<option value="Mastiff">Mastiff</option>
<option value="Mastín Español">Mastín Español</option>
<option value="Mastín Napolitano">Mastín Napolitano</option>
<option value="Pastor Aleman">Pastor Aleman</option>
<option value="Pastor Australiano">Pastor Australiano</option>
<option value="Pastor Belga">Pastor Belga</option>
<option value="Pastor Belga Malinois">Pastor Belga Malinois</option>
<option value="Pastor de Shetland">Pastor de Shetland</option>
<option value="Pastor Holandes">Pastor Holandes</option>
<option value="Pekines">Pekines</option>
<option value="Pinscher">Pinscher</option>
<option value="Pinscher Miniatura">Pinscher Miniatura</option>
<option value="Pointer">Pointer</option>
<option value="Pomerania">Pomerania</option>
<option value="Presa Canario">Presa Canario</option>
<option value="Pug">Pug</option>
<option value="Rhodesian Ridgeback">Rhodesian Ridgeback</option>
<option value="Rottweiler">Rottweiler</option>
<option value="Samoyedo">Samoyedo</option>
<option value="San Bernardo">San Bernardo</option>
<option value="Schnauzer estandar">Schnauzer estandar</option>
<option value="Schnauzer gigante">Schnauzer gigante</option>
<option value="Schnauzer miniatura">Schnauzer miniatura</option>
<option value="Scottish terrier">Scottish terrier</option>
<option value="Setter Ingles">Setter Ingles</option>
<option value="Setter Irlandes">Setter Irlandes</option>
<option value="Shar Pei">Shar Pei</option>
<option value="Shih Tzu">Shih Tzu</option>
<option value="Spitz Japones">Spitz Japones</option>
<option value="Terranova">Terranova</option>
<option value="Viejo Pastor Ingles">Viejo Pastor Ingles</option>
<option value="Weimaraner">Weimaraner</option>
<option value="Welsh Corgi Cardigan">Welsh Corgi Cardigan</option>
<option value="West highland white terrier">West highland white terrier</option>
<option value="Xoloitzcuintle">Xoloitzcuintle</option>
<option value="Yorkshire terrie">Yorkshire terrier</option>
</select> <input type="hidden" name="searching" value="yes" /> <input
type="submit" name="search" value="Search" /></form>
</body>
</html>