<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Export New System</strong></font>
<p><font face=verdana size=-2>

<form  method="post"  enctype="multipart/form-data" action="exportguide-all.cfm">

<select name="region">

<option value="Manhattan">Manhattan 

<option value="Bronx">Bronx 
<option value="Brooklyn">Brooklyn 
<option value="Fairfield">Fairfield 
<option value="Manhattan">Manhattan 
<option value="Queens">Queens 
<option value="Rockland">Rockland 
<option value="Staten Island">Staten Island 
<option value="Westchester">Westchester 
<option value="Suffolk">Suffolk 
<option value="Nassau">Nassau 
<option value="Bergen">Bergen
<option value="Essex">Essex

</select>

<SELECT SIZE="1" NAME="Advertiser">


  <OPTION VALUE="4">Premium + Basic</option>

  <OPTION VALUE="1">Premium Plus</option>
  <OPTION VALUE="0">No</option>
  <OPTION VALUE="2">Premium Lite Directional Package</option>
  <OPTION VALUE="3">Basic</option>
 

  </SELECT>
  

<cfquery name="getsites" datasource="#ds#">
select *
from ParentsListingsCatMain2011
order by catname
</cfquery>
<select name="catid">
<!--- <option value="0">All</option> --->
<cfoutput query="getsites">
<option value="#id#">#catname#</option>
</cfoutput>
</select>

<strong>Sort By: </strong>
<select name="sortby">
<option value="0">Name</option>
<option value="1">Random</option>

</select>


 <input type="submit" Value="Search"></form>
 </div>
 
 
 <Cfif parameterexists(form.catid)> 
 <cfquery name="getstuff" datasource="#ds#">
 select ParentsListings.*
 from ParentsListings
inner join ParentsListingsCat2011 on ParentsListings.id = ParentsListingsCat2011.pkid
where 1 = 1
and region = '#form.region#'

<Cfif #form.advertiser# eq 4>
and advertiser > 0

<Cfelse>
and advertiser = #form.advertiser#
</Cfif>
 <cfif #form.catid# eq 0>
 
 <cfelse> and ParentsListingsCat2011.catid = #form.catid#

 
 </cfif>
 
 <cfif #form.sortby# eq 0>
  order by name 

 <cfelse>
 
 order by rand() 
 </cfif>
 </cfquery>
 <p>

<Cfoutput query="Getstuff">
<cfif #name# is not #name[currentrow-1]#> 
<Cfquery name="getm" datasource="#ds#">
select locationmultiple,phone,website,address,city
from ParentsListings
where id = #Getstuff.id#
</CFQUERY>

<span class="adv name"><font size=+1><a href="http://nymetroparents.com/listing/#seo_friendly#">#name#<cfif #showothername# eq 'yes'><br />#othername#</cfif></a><br></span></font><span class="adv list">
<cfif #address# is not ''>#address#<br /> #city# <br></cfif>

<Cfif #phone# is not ''>#phone#<br>
</CFIF><cfif #getm.recordcount# gt 0 and #getm.locationmultiple# is not ''><br /><br />

<cfset spec = ReReplace(getm.locationmultiple,"#chr(13)##chr(10)#","<br>","ALL")>

	<Cfset spec = rereplace(spec,'http://','','ALL')>

#spec#<br /></cfif></span>

<cfif #email# is not '' and #showemail# eq 0><span class="adv email"><em>#email#</em></span><br /></cfif>

<Cfquery name="checkwrite" datasource="#ds#">
select issueguide.writeup
from issueguide
where pkid = #getstuff.id#
order by id desc
limit 0,1

</Cfquery>

<cfif #checkwrite.recordcount# gt 0>
<p><font size=+1 face=arial><span class="adv writeup"><cfset zzz = rereplace(checkwrite.writeup,'www.','','ALL')>#zzz#</span></font><br>
</cfif>
<p>
</cfif>
 </Cfoutput>
 </Cfif>
</td></tr></table>