<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
<cfif parameterexists(Session.email) and (Session.email IS NOT -1) and (#getuser.accesslevel# eq 100)>
<cfquery name="getcolumn" datasource="#ds#">
select *
from regions
where id = #url.id#
</cfquery>
<table width=600><tr><Td style="padding:5px;" >
<div align="center"><font face=verdana size=+1><strong>Edit Category</strong></font>
<br>
<FORM action="editcategory2.cfm" method=post  >
  <br>
<cfoutput query="Getcolumn" maxrows = 1>
	 <input NAME="ID" SIZE="70" value="#getcolumn.ID#" type="hidden">
   <table cellspacing=5 cellpadding=5>
	  <tr>
	  <Td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Category Name:</font></b>
	  </td><Td style="padding:5px;" >
  <input NAME="name" SIZE="70" value="#getcolumn.name#">
  </td></tr>

  <tr>
	  <Td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >SEO Friendly:</font></b>
	  </td><Td style="padding:5px;" >
  <input NAME="seo_friendly" SIZE="70" value="#getcolumn.seo_friendly#">
  </td></tr>
   
      <tr>
	  <Td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Cat Color Code (CG Only):</font></b>
	  </td><Td style="padding:5px;" >

<select name="catcode">
<option value="#getcolumn.catcode#">#getcolumn.catcode#</option>

<option value="shopping">Shopping</option>
<option value="dining">dining</option>
<option value="Activity Planner">Activity Planner</option>
<option value="culture">culture</option>
<option value="sightseeing">sightseeing</option>
<option value="theater">theater</option>
<option value="transport">transport</option>
<option value="nightlife">nightlife</option>
<option value="Cultural Arts">Cultural Arts</option>
<option value="Family Fun">Family Fun</option>
<option value="Fashion">Fashion</option>
<option value="Galleries">Galleries</option>
<option value="Health">Health</option>
<option value="Hotels">Hotels</option>
<option value="News">News</option>
<option value="People">People</option>
<option value="Real Estate">Real Estate</option>
<option value="Travel">Travel</option>

</select>


  </td></tr>

  	  <tr>
	  <Td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Category Description:</font></b>
	  </td><Td style="padding:5px;" >
	  <textarea rows="10" cols="60" name="catdescription">#getcolumn.catdescription#</textarea>
  </td></tr>

  	  <tr>
	  <Td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Category Keywords:</font></b>
	  </td><Td style="padding:5px;" >
	  <textarea rows="10" cols="60" name="catkeywords">#getcolumn.catkeywords#</textarea>
  </td></tr>
  	  <tr>
	  <Td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Hide:</font></b>
	  </td><Td style="padding:5px;" >
<select name="hide">
<cfif #getcolumn.hide# eq 1>
<option value="1">Yes</option>
</cfif>
<option value="0">No</option>
<option value="1">Yes</option>

</select>

  </td></tr>


  <tr>
	  <Td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Listings Category (Optional):</font></b>
	  </td><Td style="padding:5px;" >
<select name="catlistings">
<cfquery name="getsites" datasource="#ds#">
select *
from _SubCat
order by SubCatName
</cfquery>

<option value="#getcolumn.catlistings#">#getcolumn.catlistings#</option>

<cfloop from="1" to="#getsites.recordcount#" index="i">
<option value="#getsites.SubCatName[i]#">#getsites.SubCatName[i]#</option>

</cfloop>


</select>

  </td></tr>


  </cfoutput></table>
<center><b><input type="submit" Value="Update Site"></b></center>
</center><br>
</form>


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