//CONNECTS TO THE DATABASE AND SELECTS IT
$user="llamabre_visitor";
$password="llama";
$database="llamabre_farms1";
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");
?>
echo $name; ?>
$o++;
}
?>
Join
If you breed llamas and would
like to be added to the Breeders’ Directory, please fill out the form
below, and someone will contact you. Please note that you can join at any
time during the year, but late entries will not be included in any paper-based
publications or on the CD that is given out until the annual update. However,
your farm information will be posted online and fully visible.