<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
<cfparam name="url.mag" default="">
<cfparam name="url.issue" default=""> <cfparam name="url.catid" default="">
<cfquery name="getsites" datasource="#ds#">
select *
from issueguide
where pkid = #url.id#
order by id
</cfquery>
	<Cfquery name="getname" dataSource="#ds#">
		select name from ParentsListings where id = #url.id#
		</cfquery>

<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Manage Print Guide - <cfoutput>#getname.name#</cfoutput></strong></font><br>
 <font face=verdana size=-1><br />


<Cfoutput> 
<a href="addguide.cfm?id=#url.id#">Back to Guide Edit...</a>
</Cfoutput>
<p>
	
	<cfset days30 = dateadd('d',-4,now())>
	
	
<cfquery name="Geter" dataSource="#ds#">
	select * from newwriteupmaster
	where harddeadline > #days30#
	order by harddeadline,month,mags
</cfquery>

<Cfoutput><FORM action="addguide20152.cfm?id=#url.id#" method="post"  enctype="multipart/form-data"></cfoutput>
	<CFOUTPUT>
	<INPUT TYPE = "hidden" NAME = "NumRecords" VALUE = "#Geter.RecordCount#">
</CFOUTPUT>

	
<table border="1" cellpadding="4" cellspacing="0">
<cfoutput query="geter">
		<Cfset zzz = dateformat(geter.month,'yyyy-mm-01')>

<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#"><!---<td><a href="addguide2015.cfm?delete=#id#" onclick="return confirm('Are you sure?');">delete</a></td>	--->
<td><Font face="verdana" size="-1">#month#</td>
<td><Font face="verdana" size="-1">#mags#</td>
<td><Font face="verdana" size="-1">#directory#</td>
<td><Font face="verdana" size="-1">
		<INPUT TYPE = "hidden" NAME = "ID#CurrentRow#" VALUE = "#ID#">

	<cfquery name="getscats" dataSource="#ds#">
		select * from ParentsListingsCatMain where id in (#catnumber#)
		</cfquery>

<Cfloop from="1" to="#getscats.recordcount#" index="i">
#getscats.catname[i]# <input <Cfif #getscats.catname[i]# contains 'Edaau'>type="radio"<Cfelse>type="checkbox"</Cfif> name="addguides" value="#geter.id#|#getscats.id[i]#"><br> 
</Cfloop>

</td>

</Tr>	
	
</cfoutput>		
 </table>
<br>
<center><input type="submit" Value="Add" style="font-size:30pt;font-weight: bold;"></center>


</form>

 </font></div></td></tr></table>