function address_book()
{
$list = array();
$query = "select F1155,F1573 from clt_tab where F1573 is not null and F1573 != '' ORDER BY F1150 ASC";
if ($conn = db_connect1()) {
$result = $conn->query($query);
if (!$result) {
echo '<p>Unable to get list from database.</p>';
return false;
}
$num = $result->num_rows;
for ($i = 0; $i < $num; $i++) {
$list[$i] = $result->fetch_array();
//array_push($list, array($row[0]));
}
}
return $list;
}
function subscriber_exists($email)
{
/*if(!$email){
echo "<p>User not set</p>";
return false;
}*/
if (!($conn = db_connect1())) {
echo "<p>Could not connect to database</p>";
return false;
}
$query = "select count(*) from clt_tab where F1573 = '{$email}'";
$result = $conn->query($query);
if (!$result) {
echo "<p>No results to show</p>";
return false;
}
$row = $result->fetch_array();
return $row[0] > 0;
}
$db_user = '******';
$db_pass = '******';
//$db_pass='';
$db_name = 'CheapBeer';
//$db_name= 'cheapbeerprices';
global $connection;
$connection = mysql_connect($db_host, $db_user, $db_pass) or die("cannot connect to {$db_host} as {$db_user}" . mysql_error());
mysql_select_db($db_name) or die("Cannot open {$db_name}:" . mysql_error());
return $connection;
}
function db_close1()
{
global $connection;
mysql_close($connection);
}
db_connect1();
//CONNECT TO DATABASE RIGHT AWAY
//LOCATION VARS (only assign if set)
$location = $_GET['loc'];
$state = $_GET['state'];
echo "<main id='center' class='column'>\r\n\t<article>\r\n\t\r\n\t\r\n\t<h1 style='text-align:center;'>" . $location . ", " . $state . ".</h1><hr>\r\n\t<div style='padding: 0;border: 0;margin: 0;float:none;background-color:#707070;padding-bottom:1.25em;'>\r\n\t<table style='width:100%;margin: 0;padding: 0;'> \r\n\t\t<tr>\r\n\t\t\t<td style='text-align:center;width:20%;background-color:silver;color:white;border-bottom:none;border-left:none;'>\r\n\t\t\t\t<a href=location.php?";
//setting the link to correct vendor's summary page
if (isset($_GET['loc'])) {
if (isset($_GET['state'])) {
//only redirects when all required GETs are known
echo "loc=" . $_GET['loc'];
echo "&state=" . $_GET['state'];
echo "&view=stat";
}
}
echo " style='width: 100%;height: 100%;'>\r\n\t\t\t\t\t<h3>Location Statistics</h3></a>\r\n\r\n\t\t\t</td>\r\n\t\t\t\r\n\t\t\t<td style='text-align:center;width:20%;background-color:#707070;border-bottom:none;border-left:none;'>\r\n\t\t\t\t<h1 style='color:white'>Stores</h1>\r\n\t\t\t</td>\r\n\t\t\t<td style='text-align:center;width:20%;background-color:silver;color:white;border-bottom:none;border-left:none;'>\r\n\t\t\t\t<a href=location.php?";
