<cfinclude template="/header.cfm">
<cfif parameterexists(Session.email) and (Session.email IS NOT -1)>
<cfif (#getuser.accesslevel# eq 100)>

<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Export Online Guide</strong></font>
 <font face=verdana size=-1><br /><a href="exportguidebbm.cfm">Export Print Guide</a></div>
<p><font face=verdana size=-2>

<cfquery name="getcities" datasource="#ds#">
select distinct BBMListings.city
from BBMListings inner join issueguidebbm on BBMListings.id = issueguidebbm.pkid
order by city
</cfquery>

<form  method="post"  enctype="multipart/form-data" action="exportonlineguidebbm.cfm">
<input name="mags" type="radio" value="BBM" <cfif parameterexists(form.mags) and #form.mags# eq 'BBM'>checked</cfif>/>BBM
<Br />
<select name="issue">
<option value="March 2008">March 2008
<option value="April 2008">April 2008
<option value="May 2008">May 2008
<option value="June 2008">June 2008
<option value="July 2008">July 2008
<option value="August 2008">August 2008
<option value="September 2008">September 2008
<option value="October 2008">October 2008
<option value="November 2008">November 2008
<option value="December 2008">December 2008
<option value="January 2009">January 2009
<option value="February 2009">February 2009
<option value="March 2009">March 2009
<option value="April 2009">April 2009
<option value="May 2009">May 2009
<option value="June 2009">June 2009
<option value="July 2009">July 2009
<option value="August 2009">August 2009
<option value="September 2009">September 2009

<option value="October 2009">October 2009

<option value="November 2009">November 2009

<option value="December 2009">December 2009
<option value="January 2010">January 2010
<option value="February 2010">February 2010
<option value="March 2010">March 2010
<option value="April 2010">April 2010
<option value="May 2010">May 2010
<option value="June 2010">June 2010
<option value="July 2010">July 2010
<option value="August 2010">August 2010
<option value="September 2010">September 2010
<option value="October 2010">October 2010
<option value="November 2010">November 2010
<option value="December 2010">December 2010
<option value="January 2011">January 2011
<option value="February 2011">February 2011
<option value="March 2011">March 2011
<option value="April 2011">April 2011
<option value="May 2011">May 2011
<option value="June 2011">June 2011
<option value="July 2011">July 2011
<option value="August 2011">August 2011
<option value="September 2011">September 2011
<option value="October 2011">October 2011
<option value="November 2011">November 2011
<option value="December 2011">December 2011

</select>

<cfquery name="getsites" datasource="#ds#">
select *
from BBMCatMain
order by catname
</cfquery>
<select name="catid">
<option value="0">All</option>

<cfoutput query="getsites">
<option value="#id#">#catname#</option>
</cfoutput>
</select>
<select name="city">
<cfif #parameterexists(form.city)#><Cfoutput><option value="#form.city#">#form.city#</Cfoutput>
</cfif><option value="All">All
<cfoutput query="getcities">
<option value="#city#">#city#

</cfoutput></option>
</select>

 <input type="submit" Value="Search"></form>
 
 <cfif parameterexists(form.issue)>
 
 <cfquery name="getstuff" datasource="#ds#">
 select issueguidebbm.writeup, issueguidebbm.pkid, issueguidecatbbm.issue,issueguidecatbbm.mags,issueguidebbm.offer,issueguidebbm.expirationdate,issueguidecatbbm.issueguideid,BBMListings.*,BBMCatMain.catname as category
 from issueguidebbm inner join issueguidecatbbm on issueguidecatbbm.issueguideid = issueguidebbm.id inner join BBMListings on issueguidebbm.pkid = BBMListings.id inner join BBMCatMain on issueguidebbm.catid = BBMCatMain.id
 where 
 issueguidecatbbm.issue = '#form.issue#' and issueguidecatbbm.mags like '%#form.mags#%' <cfif #form.city# is not 'All'>and city = '#form.city#'</cfif>
 <cfif #form.catid# eq 0>
 
 <cfelse> and issueguidebbm.catid = #form.catid#

 
 </cfif>

  order by BBMCatMain.catname,BBMListings.name
 </cfquery>
 <p>
 <font face=verdana size=-1>
 <Cfoutput query="getstuff">
 <Cfif #category# is not #getstuff.category[currentrow-1]#>
<font size=+2><b><strong>#category#</strong></b></font>
<p>


</Cfif><cfif #publishedname# eq ''><strong>#ucase(name)#<br /></strong><cfelse>
<strong>#replace(publishedname, chr(10), "<br />", "All")#</strong></cfif></a>

<cfif #address# is not ''>#address#, #city#<br /></cfif>
<cfif #phone# is not ''>#phone#<br /></cfif>
<cfif #locationmultiple# is not ''>#replace(locationmultiple, chr(10), "<br />", "All")#<br /></cfif>
<cfif #website# is not ''><a href="http://#website#" target="new">#website#<br /></a></cfif>
<cfif #showemail# eq 0 and #email# is not ''>Email #email#<br /></cfif>
<cfif #offer# is not ''><font face=arial size=+0>#offer#</font><br /></cfif>
<p><font size=+1 face=arial>#writeup#</font><br>

<cfif #expirationdate# is not ''><font face=times>#expirationdate#</font><br /></cfif>
 
  </Cfoutput></cfif>

 
</td></tr></table>

</cfif>
</cfif>
<cfinclude template="/footer.cfm">