<? require "header.php";
if(!is_numeric($_REQUEST[id])) { exit(); } 
if($_POST) {
	$_POST = mysql_real_escape_array($_POST); 
	$_POST[name] = strip_tags($_POST[name]); 
	$_POST[description] = mysql_real_escape_string($_POST[description]);
	$_POST[metakw] = mysql_real_escape_string($_POST[metakw]);
	$_POST[metadesc] = mysql_real_escape_string($_POST[metadesc]);
	mysql_query("UPDATE niches SET name = '$_POST[name]', description = '$_POST[description]', metakw = '$_POST[metakw]', metadesc = '$_POST[metadesc]', csv_match = '$_POST[csv_match]' WHERE 
record_num = '$_POST[id]'");
	$insertid = $_POST[id];
	if($_FILES[postroll][tmp_name]) {
		$name = 'cat'.$insertid.'.jpg';
		move_uploaded_file($_FILES[postroll][tmp_name], $misc_path.'/'.$name); 
	}	$success = true;
}
$result = mysql_query("SELECT * FROM niches WHERE record_num = '$_GET[id]'");
$row = mysql_fetch_array($result); 
?>

     <div id="right_column">
        <!-- RIGHT -->
        <div id="right_top">
        	<div id="right_home"></div>
            <div id="right_right">  
            <a href="index.php">Admin Home</a>          
            </div>
        </div>
        
        
        
        <div id="right_bg">
        
      		<h2>Edit<strong>Channel</strong></h2>
            
            <div id="index_left" style='width: 100%;'>            
            
            
<form method='post' action='' enctype='multipart/form-data'>
<input type='hidden' name='id' value='<? echo $_GET[id]; ?>' />
<? if($success) { ?><p align='center'>Save Successful. <a href='niches.php'>Click here to go back</a>.</p>
<? } ?>
<table width="750" border="0" align="center" cellpadding="3" cellspacing="0" >
  <tr>
    <td width="79" height="25" valign="top" class="style4">Name</td>
    <td width="393" height="25" align="left" valign="top" class="style4"><input name="name" type="text" class="style4" id="name" value="<? echo $row[name]; ?>" size="35" maxlength="255" /></td>
  </tr>
    <tr>
      <td height="25" valign="top" class="style4">Current Image</td>
      <td height="25" align="left" valign="top" class="style4"><? if(file_exists($misc_path.'/cat'.$row[record_num].'.jpg')) { ?>
        	<img src="<? echo $misc_url; ?>/cat<? echo $row[record_num]; ?>.jpg" alt="<? echo $row[name]; ?>" height="90" width="120" border=0 />						 		<? } else { ?>
            <img src="<? echo $basehttp; ?>/core/images/catdefault.jpg" alt="<? echo $row[name]; ?>"   width="<? echo $thumbwidth  ?>">
        <? } ?></td>
    </tr>
    <tr>
    <td height="25" valign="top" class="style4">New Image</td>
    <td height="25" align="left" valign="top" class="style4"><input type="file" name="postroll" id="postroll" /></td>
  </tr>
<tr>
      <td height="25" class="style4">Meta KW</td>
      <td height="25" align="left" class="style4"><input name="metakw" type="text" class="style4" id="name3" size="35" maxlength="255" value="<? echo $row[metakw]; ?>" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Meta Desc</td>
      <td height="25" align="left" class="style4"><input name="metadesc" type="text" class="style4" id="name4" size="35" maxlength="255" value="<? echo $row[metadesc]; ?>"  /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Description</td>
      <td height="25" align="left" class="style4"><textarea name="description" cols="35" rows="4" class="style4" id="name2"><? echo $row[description]; ?></textarea></td>
    </tr>
<tr>
      <td height="25" class="style4">Import Match</td>
      <td height="25" align="left" class="style4"><input name="csv_match" type="text" class="style4" id="name3" size="35" maxlength="255" value="<? echo $row[csv_match]; ?>" /></td>
    </tr>

  <tr>
    <td height="25" colspan="2" align="center" class="style4"><input type="submit" name="Submit2" value="Save" /></td>
  </tr>
</table>
</form>
            
            
            </div>
            
          
        
        </div>
        
        <div id="right_bottom"></div>
       
        <!-- RIGHT -->
        
        
        
        <!-- STATYSTYKI -->
      
        
      
        </div>
       <!-- STATYSTYKI -->       
        
    
    
    </div>
  



</div>






        
<? require "footer.php"; ?>