<?php
$connection = mysql_connect('localhost',"sernec","sernec");
if(!$connection){ die('Not connected : '.mysql_error()); }

$db_selected = mysql_select_db("SERNEC",$connection);
if(!$db_selected){  die('Cant use db: '.mysql_error()); }

if (isset($_GET["state"])) {
    $state_name = $_GET["state"];
//    echo $_GET['state_name'];
}
else
    echo "didn't get it";
if (isset($_GET["county"])) {
    $county_name = $_GET["county"];
  //  echo $_GET['county_name'];
}
else
    echo "didn't get it";
if (isset($_GET["genus"])) {
    $genus = $_GET["genus"];
    //echo $_GET['state_name'];
}
else
    echo "didn't get it";

echo  "\"state_name\"" . ",". "\"county_name\"". "," . "\"fips\"" . "," . "\"count\"" . "," . "\"entries\"" . ",";
for($i=1;$i<=85;$i++)
{
echo "\"lat$i\"". ",". "\"lng$i\"".",";
}
if(!$_GET["county"] && !$_GET["genus"]){
$query = "select * from SECountiesEntries s, Tennessee t where s.fips=t.Fips and t.State='".$state_name."'";
}
elseif(!$_GET["genus"]){
$query = "select * from SECountiesEntries s, Tennessee t where s.fips=t.Fips and t.State='".$state_name."' and t.County='".$county_name."'";
}
else{
$query = "select * from SECountiesEntries s, Tennessee t where s.fips=t.Fips and t.State='".$state_name."' and t.County='".$county_name."' and t.Genus='".$genus."'";
}
$result = mysql_query($query);
if(!$result){
die('Invalid query: ' .mysql_error());
}

while($row = mysql_fetch_row($result))
{
  for($i=0;$i<=6;$i++)
  {
    echo $row[$i]. ",";
  }
  echo "\n";
}
mysql_close($connection);
?>