array('Alabama', 'Alaska', 'Arizona', 'Arkansas', 'California', 'Colorado', 'Connecticut', 'Delaware', 'Florida', 'Georgia', 'Hawaii', 'Idaho', 'Illinois', 'Indiana', 'Iowa', 'Kansas', 'Kentucky', 'Louisiana', 'Maine', 'Maryland', 'Massachusetts', 'Michigan', 'Minnesota', 'Mississippi', 'Missouri', 'Montana', 'Nebraska', 'Nevada', 'New Hampshire', 'New Jersey', 'New Mexico', 'New York', 'North Carolina', 'North Dakota', 'Ohio', 'Oklahoma', 'Oregon', 'Pennsylvania', 'Rhode Island', 'South Carolina', 'South Dakota', 'Tennessee', 'Texas', 'Utah', 'Vermont', 'Virginia', 'Washington', 'West Virginia', 'Wisconsin', 'Wyoming'), "Canada" => array('Alberta', 'British Columbia', 'Manitoba', 'New Brunswick', 'Newfoundland & Labrador', 'Northwest Territories', 'Nova Scotia', 'Nunavut', 'Ontario', 'Prince Edward Island', 'Quebec', 'Saskatchewan', 'Yukon'));
$abbrevs = array("United States" => array('al', 'ak', 'az', 'ar', 'ca', 'co', 'ct', 'de', 'fl', 'ga', 'hi', 'id', 'il', 'in', 'ia', 'ks', 'ky', 'la', 'me', 'md', 'ma', 'mi', 'mn', 'ms', 'mo', 'mt', 'ne', 'nv', 'nh', 'nj', 'nm', 'ny', 'nc', 'nd', 'oh', 'ok', 'or', 'pa', 'ri', 'sc', 'sd', 'tn', 'tx', 'ut', 'vt', 'va', 'wa', 'wv', 'wi', 'wy'), "Canada" => array('ab', 'bc', 'mb', 'nb', 'nl', 'nt', 'ns', 'nu', 'on', 'pe', 'qb', 'sk', 'yt'));
$topten = $arr = array();
$key = false;
foreach($abbrevs as $country => $regions)
{
if (array_search($needle, $regions) !== false)
{
$cntry = $country;
$key = array_search($needle, $regions);
}
}
if ($cntry == 'United States')
{
$porz = $fporz = 'state';
$views = array('v_us5', 'v_us9', 'v_us10');
}
else
{
$porz = 'prov';
$fporz = 'province';
$views = array('v_cn6', 'v_cn7');
}
foreach ($views as $table)
{
$query = 'select v.`item_id`, v.`item_sum`, v.`pname`, p.`pimage` from `' . $table . '` v, `zsf_products` p where v.`pname` = p.`pname` and v.`' . $porz . '` = \'' . $needle . '\' limit 20';
#echo "$query
\n";
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$topten[$item_id][0] = $item_id;
$topten[$item_id][1] = $pname;
$topten[$item_id][2] = $pimage;
$topten[$item_id][3] += $item_sum;
}
}
$keys = array_keys($topten);
for ($i = 0; $i < 20; $i++)
{
$k = array_shift($keys);
$arr[$k] = $topten[$k];
}
//print_arr($topten);
$query = 'select `id`, `hname` from `zsf_resheader` order by `sort`';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$resources[$id] = $hname;
}
$query = 'select `id`, `resheader_fk`, `title`, `url` from `zsf_reslistings` where `abbr_fk` = \'' . $needle . '\' order by `id`';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$reslistings[$resheader_fk][$id] = array($title, $url);
}
$query = 'select `id`, `name`, `addr1`, `addr2`, `city`, `zip`, `phone`, `website` from `zsf_resflyshops` where `state` = \'' . $needle . '\' order by `id`';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$reslistings[6][$id] = array($name, $addr1, $addr2, $city, $zip, $phone, $website);
}
?>
[ map ]
0)
{
$pdir = 'flies';
echo '
';
$str .= $hname . ' ';
echo $str;
}
}
?>
[ map ]
'. "\n"; foreach($reslistings[$key] as $id => $urlarr) { if ($key <> 6) { list ($title, $url) = $urlarr; $str .= '' . $title . ' '. "\n"; } else { list ($name, $addr1, $addr2, $city, $zip, $phone, $website) = $urlarr; $str .= ' ' . $name . ' \n";
}
}
$str .= '' . $addr1; if ($addr2) { $str .= ', ' . $addr2; } $str .= ', ' . $city . ', ' . strtoupper($needle) . ', ' . $zip . ' ' . $phone; if ($website) { $str .= ' Web site: ' . $website . ''; } $str .= " |