<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">					<table border="0" cellpadding="8" cellspacing="0" width="100%">
					<tr>
					<td valign="top">

<span class="header">Manage Highlight Listing</span></strong><br>
<cfoutput><table width=100% cellspacing=0 cellpadding=0 bgcolor=#color#><tr><td></td></tr></table></cfoutput>

<p>


<font face=verdana size=-1> <b> City Guide Category Picker:
</b>
<br>
<Cfquery name="Getregions" datasource="#ds#">
SELECT *
FROM mainlistingscats
order by maincatname
</CFQUERY>

<cfquery name="Getarticleregions" datasource="#ds#">
select *
from mainlistings
where listingsid = #url.itemid# and tablename = '#url.tablename#'
</cfquery>


<FORM action="managehighlight2.cfm" method=post>
<br><cfoutput>
<input name="id" type="hidden" value="#url.itemid#">
<input name="tablename" type="hidden" value="#url.tablename#"></cfoutput>
<select name="regions" multiple size="20">
<Cfoutput query="getregions">
<Cfset ab = 'on'>
<cfloop from="1" to="#Getarticleregions.recordcount#" index="i">
<cfif #Getarticleregions.maincatid[i]# eq #getregions.maincatid#>
 <Cfset ab = 'off'>
 <option value="#getregions.maincatid#" selected>#getregions.maincatname#</option>
 <cfelse>
 
  </cfif>
</cfloop>  
<Cfif parameterexists(ab) and #ab# eq 'on'>
  <option value="#getregions.maincatid#">#getregions.maincatname#</option>
</CFIF>

 </CFOUTPUT>  
</select>
<br>

<input type="submit" Value="Update Listing">
</form>
</td></tr></table>
<cfinclude template="footer.cfm">