//CONNECTS TO THE DATABASE AND SELECTS IT
$user="llamagen_breeder";
$password="llamagen_breeder";
$database="llamagen_breeder";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
//SELECTS EVERYTHING IN THE TABLE llamadir
$selectedstate = $_POST['select'];
if ($selectedstate === NULL) {
$selectedstate = $_GET['state'];
}
$query1 = "SELECT * FROM farmsdir WHERE state='$selectedstate' ORDER BY name ASC";
$query2 = "SELECT * FROM statesdir WHERE state='$selectedstate'";
$result1 = mysql_query($query1);
$result2 = mysql_query($query2);
?>
$num2 = mysql_numrows($result1);
$o = 0;
while ($o<$num2) {
$name=mysql_result($result1,$o,"name");
?>
All farms on file are listed below according to their state. If you do not see a state listed, it simply means that
there are no farms for that state currently in our database.