After I make the call to the database I am trying to create a drop down on the fly. Here is my code but I am getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/beachweb/beachbreeders-www/horsesearch.php on line 39
while ($r=mysql_fetch_array ($result) )
{
$HorseArr[]=$r["PetBreed"];
}
$box=make_options($HorseArr,"PetBreed",1);
// for example continue like this:
echo "<FORM ACTION=showanimals.php>\n";
echo $box."\n";
echo "<INPUT TYPE=SUBMIT NAME=AnimalSearch VALUE=SHOW>\n";
echo "<INPUT TYPE=HIDDEN NAME=hiddenAnimal VALUE=Horse>\n";
echo "</FORM>\n";
exit;
Thanks in Advance