<% require("../include_function.php"); require("../_private/dbconnect.php"); %> <% $data = include_html("../include_aeg_menu.html",""); echo($data); %>
<% $data = include_html("../include_menu.html",""); echo($data); %>
<% $data = include_html("../include_flash.html",""); echo($data); %>

Retailer Registry

Choose the area you wish to search for retailers:
Country:   State:
(State overrides Country selection)

<% if (isset($_POST[submit])) { echo "

Results

"; //default search always includes country $searchterms="country='$_POST[country]'"; //determine all states or a specific one if($_POST[state] != "0") { $searchterms="state='$_POST[state]'"; } //Testing searchterms by showing them echo "Searching for: $searchterms
"; $query="SELECT * FROM retailernew WHERE $searchterms"; $result=mysql_db_query($db, $query ,$connection) or die("Error in query."); //Output results in a table %> <% while($myrow = mysql_fetch_array($result)) { $store = $myrow["store_name"]; $address = $myrow["address"]; $city = $myrow["city"]; $state = $myrow["state"]; $country = $myrow["country"]; $zip = $myrow["zip"]; $areacode = $myrow["areacode"]; $phone = $myrow["phone"]; $website = $myrow["website"]; $l5rccg = $myrow["L5RCCG"]; $rokugan = $myrow["AEGd20"]; $l5rrpg = $myrow["L5RRPG"]; $spycraftrpg = $myrow["SpycraftRPG"]; $warlordccg = $myrow["WarlordCCG"]; $spycraftccg = $myrow["SpycraftCCG"]; $sniperleague = $myrow["SniperLeague"]; %>

<% echo $store; %>
<% echo $address; %>
<% echo $city; %>, <%echo $state; %> <% echo "$country $zip"; %>
<% if ($phone && $phone != "none") { %> Phone: <% echo "$areacode $phone"; %>
<% } %> <% if ($fax && $fax != "none") { %> Fax: <% echo $fax; %>
<% } %> <% if ($website && $website != "none") { %> Web: <% echo $website; %>
<% } %> Game Lines: <% if ($l5rccg == "Yes") { %> L5RCCG, <% } %> <% if ($rokugan == "Yes") { %> Rokugan RPG, <% } %> <% if ($l5rrpg == "Yes") { %> L5R RPG, <% } %> <% if ($warlordccg == "Yes") { %> Warlord CCG, <% } %> <% if ($warlordrpg == "Yes") { %> Warlord RPG, <% } %> <% if ($spycraftrpg == "Yes") { %> Spycraft RPG, <% } %> <% if ($spycraftccg == "Yes") { %> Spycraft CCG, <% } %> <% if ($sniperleague == "Yes") { %> Spycraft Sniper League; <% } %>

<% } %> <% // memory flush mysql_free_result($result); } %>

------------------------

<% $data = include_html("../include_footer.html",""); echo($data); %>