ecosmar_friendly

ml_temp
Field Type Null Default Links to 
ID  int(11) No        
subject  varchar(240) No        
greeting  varchar(120) No        
message  text No        
link_ex  text No        
link  varchar(240) No        
closing  varchar(120) No
listit  text No
+++++++leftit  text No        
dtnum  int(8) No        


Indexes: Keyname Type Cardinality Field 
PRIMARY  PRIMARY 0   ID  


Space usage: Type Usage 
Data 0 B 
Index 1,024 B 
Total 1,024 B 
   Row Statistics: Statements Value 
Format dynamic  
Rows 0  
Next Autoindex 1  
Creation Apr 14, 2007 at 08:31 AM  
Last update Apr 14, 2007 at 08:31 AM  
 



ID
subject
greeting
message
link_ex
link
closing
listit
leftit
dtnum

ID,subject,greeting,message,link_ex,link,closing,listit,leftit,dtnum




<tr><td style='border-top:solid brown 1;font-size:12;text-align:center;padding-top:6;padding-bottom:6;'>
<b>Email Templates:</b>
<?
mysql_select_db('ecosmar_friendly', $dbcnx);
$temp = @mysql_query("SELECT ID,subject,dtnum FROM ml_temp ORDER BY dtnum");
if(!$temp){
echo("<p>Error retrieving Email Templates.<br/> " . "Error: " . mysql_error(). "</p>");
}else{
$t_count = mysql_num_rows($temp);
if($t_count == 0 or $t_count == ""){
echo("<span class='tiny'>Templates are copies of sent email that you can use again.<br/>The template records recipients to avoid duplication.</span>");
}elseif($t_count < 3){
echo("<span class='tiny'>You have $t_count Email Templates. Template Capacity is 3.<br/>Click the template subject below to edit or delete template.</span>");
}elseif($t_count >= 3){
echo("<span class='tiny'>FULL CAPACITY - Template Capacity is 3. You must delete a template before saving any more.<br/>Click the template subject below to edit or delete.</span>");
}
while($row = mysql_fetch_array($temp)){
$TID = $row[0];
$t_sub = $row[1];
$t_dtnum = $row[2];
echo("<input type='radio' name='temp' value='$TID'/>&nbsp;$t_sub" .
"&nbsp;<a href='ml_temp_edit.php?ursn=$usrn&fr=$dnum&ID=$TID'>[Edit]</a>&nbsp;&nbsp;&nbsp;");
}
}
?>
</td></tr>