<?php 
// Connection to the db server and select active db 
$SQLlink = @mysql_connect("sql.com", "wnyaic", "immunize"); //creates a connection 

if (!$SQLlink) 
 Die("Couldn't connect to the db server."); // display error message on error 

if (!mysql_select_db("immunizewnyorg", $SQLlink)) 
 Die("Couldn't access database.");     // display error message on error 

// perform query 
$data  = mysql_query("SELECT date, agency, city FROM agencies"); 

if (!$data) 
 Die(mysql_error());            // display MySQL error message on error 

$agencies = Array(); 

while($row = mysql_fetch_array($data)) {   // assign results into arrays 
 $dates[]  = $row["date"]; 
 $agencies[] = $row["agency"]; 
 $cities[]  = $row["city"]; 
} 

$dates = Array_Unique($dates);        // remove duplicate values 
$agencies = Array_Unique($agencies); 
$cities = Array_Unique($cities); 

Sort($dates);                // sort arrays 
Sort($agencies); 
Sort($cities); 

$date_out  = "<select name='date'  onchange=\"window.open('results.php?action=date&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 
$agency_out = "<select name='agency' onchange=\"window.open('results.php?action=agency&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 
$city_out  = "<select name='city'  onchange=\"window.open('results.php?action=city&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 

$date_out  .= "<option>-- select date ---</option>"; 
$agency_out .= "<option>-- select agency ---</option>"; 
$city_out  .= "<option>-- select city ---</option>"; 

forEach ($dates as $value) 
 $date_out  .= "<option value='$value'>$value</option>"; 

forEach ($agencies as $value) 
 $agency_out .= "<option value='$value'>$value</option>"; 

forEach ($cities as $value) 
 $city_out  .= "<option value='$value'>$value</option>"; 


$date_out  .= "</select>\n"; 
$agency_out .= "</select>\n"; 
$city_out  .= "</select>\n"; 

echo $date_out."<BR>"; 
echo $agency_out."<BR>"; 
echo $city_out."<BR>"; 

?>

<?php 

if (!IsSet($action) || !IsSet($value))    // check if both vars are set 
 Die("Both vars must be set"); 

if (Trim($value) == "")           // check if value is non-blank 
 Die("Value can't be left blank"); 

if ($action != "date" && $action != "agency" && $action != "city") 
 Die("Unknown action requested"); 

// Connection to the db server and select active db 
$SQLlink = @mysql_connect(".com", "wnyaic", "947"); //creates a connection 

if (!$SQLlink) 
 Die("Couldn't connect to the db server."); // display error message on error 

if (!mysql_select_db("immunizewnyorg", $SQLlink)) 
 Die("Couldn't access database.");     // display error message on error 

// escape data from user 
if (ini_get('magic_quotes_gpc')) {      // unescaping data if needed 
 $value = StripSlashes($value); 
} 
$value = mysql_escape_string($value);    // escaping data for MySQL db 


$data = mysql_query("SELECT date, agency, city FROM agencies WHERE $action = '$value'"); // perform a query 

if (!$data) 
 Die(mysql_error());            // display MySQL error message on error 

$agencies = Array(); 

while($row = mysql_fetch_array($data)) { 
 $agencies[] = $row; 
} 

$output = "<table border=1>\n"; 
if (mysql_num_rows($data) == 0) {      // in the case of no results found - display alert message 
 $output .= "<tr><td colspan=3>No results found</td></tr>"; 
 
} else { 
 forEach ($agencies as $agency) {      // display row for each result (eg. you can have more agencies in one town) 
  $output .= "<tr>"; 
  $output .= "<td>".$agency["date"]."</td>"; 
  $output .= "<td>".$agency["agency"]."</td>"; 
  $output .= "<td>".$agency["city"]."</td>"; 
 
$output .= "</tr>\n"; 
 } 
} 

$output .= "</table>\n"; 

echo $output; 

?>

echo "<table border=1>";
if (mysql_num_rows($data) <> 0)
{
     forEach ($agencies as $agency)
     {
           echo "<tr>";
           echo "<td>{$agency['date']}</td>";
           echo "<td>{$agency['agency']}</td>";
           echo "<td>{$agency['city']}</td>";
           echo "<td>{$agency['day']}</td>";
           echo "<td>{$agency['time']}</td>";
           echo "<td>{$agency['location']}</td>";
           echo "<td>{$agency['building_room']}</td>";
           echo "<td>{$agency['street']}</td>";
           echo "<td>{$agency['zip']}</td>";
           echo "<td>{$agency['phone']}</td>";
           echo "<td>{$agency['contact']}</td>";
           echo "</tr>";
      }
}
else
{
      echo "<tr>";
      echo "<td>No Results Found!</td>";
      echo "</tr>";
}

echo "</table>";