<?php echo $countries[$cntry][$key]; ?> - selling flies / Fly Fishing Flies Cost Less at Streamflies Online Fly Shop

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); } ?> <?php echo $countries[$cntry][$key]; ?> - selling flies / Fly Fishing Flies Cost Less at Streamflies Online Fly Shop

Testimonials

[ map ]

0) { $pdir = 'flies'; echo '' . "\n"; echo ''; for ($i = 1; $i <= 5; $i++) { list ($id, $pname, $pimage, $psum) = array_shift($arr); if ($pimage) { $href = '"/products/detail.html?i=' . $id . '&c=' . $item . '"';// target="_blank"'; echo ''; ++$n; } else { echo ''; } } echo '' . "\n"; } echo '

Top-selling flies in ' . $countries[$cntry][$key] . '. ' . "\n"; $n = 0; while ($arr) { echo '
'; echo '' . $pname . '

' . "\n"; } ?> $hname) { if (count($reslistings[$key]) > 0) { $str = '

'; $str .= $hname . '
'. "\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 . '
' . $addr1; if ($addr2) { $str .= ', ' . $addr2; } $str .= ', ' . $city . ', ' . strtoupper($needle) . ', ' . $zip . '
' . $phone; if ($website) { $str .= '
Web site: ' . $website . ''; } $str .= "

\n"; } } $str .= '

'; echo $str; } } ?> [ map ]