<?php 
include_once("session.php");
include_once("settings.php");
include_once("functions.php");
//echo '<pre>';
//print_r($_REQUEST); 
if($_REQUEST['action'] == 'DeleteCategory'){

    //Image Remove Code from file
    $Image_Data="select * from tbl_downloads where id = '" .$_REQUEST['id']. "'"; 
    $query=  mysql_query($Image_Data); 
    $rows = mysql_fetch_assoc($query);
    $image_path = @unlink("../cat_images/downloads/".$rows['image']);
    $image_path1 = @unlink("../cat_images/downloads/".$rows['upload_file']);
    
    //Image Remove Code from db
    $sql = "delete from  tbl_downloads where id = '".$_REQUEST['id']."'";
    mysql_query($sql) or die(mysql_error()); 
}
?> 


<LINK href="mel.css" type=text/css 
rel=stylesheet><LINK href="sdmenu.css" 
type=text/css rel=stylesheet>
<table width="94%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td>
        <fieldset>
      <legend>Downloads Manager LIST FORM</legend>
 
      <table width="100%" border="0" cellspacing="2" cellpadding="0">
        <?php
		  if($msg!=""){ ?>
        <tr valign="middle" class="general"> 
          <td height="26" colspan="3" align="center"> 
            <?=$msg;?>
          </td>
        </tr>
        <?php } ?>
        <tr valign="middle" class="general"> 
          <td height="26" colspan="3"><input type="button" name="btnadd" value="Add download" class="button" onclick="window.location.href='downloads_add.php?mode=Add&page=adddownloads'" style="width:150px" /></td>
        </tr>
        <tr valign="middle" class="general"> 
          <td width="42%" height="26">title</td>
          <td width="38%" height="26" align="left" valign="middle" >Status
            </td>
          <td width="20%" align="center" >Action</td>
        </tr>
        <?php
                    $sql="select * from  tbl_downloads order by id";
                    $result=mysql_query($sql);
                    
                    while($arrayCategory=mysql_fetch_assoc($result))
                        
				{	  
		?>
        <tr valign="middle" class="generaltxt"> 
          <td height="26">      
            <?=$arrayCategory['title']?>
          </td>
          <td height="26" align="left">
         <?=get_record_data('tbl_home_banner','status',$arrayCategory['status'],'status'); ?></td>
          <td align="center"> 
              <a href="downloads_add.php?id=<?=$arrayCategory['id']?>&mode=Edit&page=adddownloads" class="action1"><strong>Edit</strong></a> 
              | <a href="downloads_list.php?id=<?=$arrayCategory['id']?>&action=DeleteCategory" onClick="return confirm('Are you sure you want to delete this  record?')" class="action1"><strong>Delete</strong></a> 
          </td>
        </tr>
        <?php    } ?>
        <tr align="right" valign="middle" class="generaltxt"> 
          <td height="10" colspan="3">&nbsp;</td>
        </tr>
        <tr align="right" valign="middle" class="generaltxt"> 
          <td height="26" colspan="3"><input type="button" name="btnadd2" value="Add download" class="button" onclick="window.location.href='downloads_add.php?mode=Add&page=adddownloads'" style="width:150px" /></td>
        </tr>
      </table>
        
        </fieldset>
      </td>
  </tr>
</table>