<?php
error_reporting(0);
@session_start();
include("config.php");

$flag = $_REQUEST[flag];
$mode = $_REQUEST[mode];

/***********************************/
$id= $_POST[id];
if($id=="")
{ 
    	 $query_insert=sprintf("Insert INTO client_advertisement SET typ='client'");
		 if(!($resi=mysql_query($query_insert))){echo $query_insert.mysql_error(); exit;}
		 
		 $id = mysql_insert_id(); 
		if($_FILES["advimge"]["name"]!="") 
		{
				 
			 $fileload = $_FILES["advimge"]["name"];
			
			 $file_ext = explode(".",$fileload);
			 $myattach="advimge_".$id.".".$file_ext[1];
			 
			$destpath=$uploadpath.$myattach;
				 
			$file1 = move_uploaded_file($_FILES["advimge"]["tmp_name"],$destpath); 
			$updatecategory=sprintf("UPDATE client_advertisement SET advimge ='%s' WHERE id ='%d'", $myattach, $id); 
			if(!($result = mysql_query($updatecategory))){echo $updatecategory.mysql_error();exit;}
		}		
		 header("Location:add-adv.php?flag=dn");
		exit;
}
$id= $_POST[id];
if($id!="")
{
          $query_up=sprintf("UPDATE client_advertisement SET typ='client' WHERE id='%d' ",$id); 
		  if(!($resu=mysql_query($query_up))){echo $query_up.mysql_error(); exit;}
		
		if($_FILES["advimge"]["name"]!="") 
		{
				 
			 $fileload = $_FILES["advimge"]["name"];
			
			 $file_ext = explode(".",$fileload);
			 $myattach="advimge_".$id.".".$file_ext[1];
			 
			$destpath=$uploadpath.$myattach;
				 
			$file1 = move_uploaded_file($_FILES["advimge"]["tmp_name"],$destpath); 
			$updatecategory=sprintf("UPDATE client_advertisement SET advimge ='%s' WHERE id ='%d'", $myattach, $id); 
			if(!($result = mysql_query($updatecategory))){echo $updatecategory.mysql_error();exit;}
		}		
          header("Location:add-adv.php?flag=up");
		  exit;
		
}
?>