if(isset($_POST['man_id']))
$man_id=$_POST['man_id'];

$query=mysql_query('SELECT m_info.*, m.manufacturers_image FROM '.TABLE_MANUFACTURERS_INFO.' AS m_info, '.TABLE_MANUFACTURERS.' AS m WHERE m_info.manufacturers_id="'.$man_id.'" and m.manufacturers_id="'.$man_id.'" order by m_info.manufacturers_id');
(empty($_POST['man_name_rus'])!=true) ? $man_name_rus=$_POST['man_name_rus'] : $man_name_rus=mysql_result($query, 0, 'manufacturers_name');
(empty($_POST['man_name_eng'])!=true) ? $man_name_eng=$_POST['man_name_eng'] : $man_name_eng=mysql_result($query, 1, 'manufacturers_name');
(empty($_POST['description_rus'])!=true) ? $description_rus=$_POST['description_rus'] : $description_rus=mysql_result($query, 0, 'manufacturers_description');
(empty($_POST['description_eng'])!=true) ? $description_eng=$_POST['description_eng'] : $description_eng=mysql_result($query, 1, 'manufacturers_description');
(empty($_POST['meta_title_rus'])!=true) ? $meta_title_rus=$_POST['meta_title_rus'] : $meta_title_rus=mysql_result($query, 0, 'manufacturers_meta_title');
(empty($_POST['meta_title_eng'])!=true) ? $meta_title_eng=$_POST['meta_title_eng'] : $meta_title_eng=mysql_result($query, 1, 'manufacturers_meta_title');
(empty($_POST['meta_key_rus'])!=true) ? $meta_key_rus=$_POST['meta_key_rus'] : $meta_key_rus=mysql_result($query, 0, 'manufacturers_meta_keywords');
(empty($_POST['meta_key_eng'])!=true) ? $meta_key_eng=$_POST['meta_key_eng'] : $meta_key_eng=mysql_result($query, 1, 'manufacturers_meta_keywords');
(empty($_POST['meta_desc_rus'])!=true) ? $meta_desc_rus=$_POST['meta_desc_rus'] : $meta_desc_rus=mysql_result($query, 0, 'manufacturers_meta_description');
(empty($_POST['meta_desc_eng'])!=true) ? $meta_desc_eng=$_POST['meta_desc_eng'] : $meta_desc_eng=mysql_result($query, 1, 'manufacturers_meta_description');
if(empty($_FILES['man_pic']['tmp_name'])!=true)
{
$man_pic=$_FILES['man_pic']['name'];
$man_pic_tmp=$_FILES['man_pic']['tmp_name'];
#upload_image
$size=getimagesize($man_pic_tmp);
}
else
{
$man_pic=mysql_result($query, 0, 'manufacturers_image');
}
(empty($_POST['url_rus'])!=true) ? $url_rus=$_POST['url_rus'] : $url_rus=mysql_result($query, 0, 'manufacturers_url');
(empty($_POST['url_eng'])!=true) ? $url_eng=$_POST['url_eng'] : $url_eng=mysql_result($query, 1, 'manufacturers_url');
(empty($_POST['email'])!=true) ? $email=$_POST['email'] : $email=mysql_result($query, 0, 'email');

$account_query = tep_db_query('select customers_email_address from ' . TABLE_CUSTOMERS . ' where customers_id = "' . (int)$customer_id . '"');
$account = tep_db_fetch_array($account_query);

//-------insert data-------------------------------------------------------------------------------------------------------------------------------------------------
if(isset($_POST['editm']))
{//main
if(mysql_query('UPDATE '.TABLE_MANUFACTURERS_INFO.' SET (manufacturers_name="'.$manufacturers_name.'", manufacturers_description="'.$manufacturers_description.'", manufacturers_meta_title="'.$manufacturers_meta_title.'", manufacturers_meta_keywords="'.$manufacturers_meta_keywords.'", manufacturers_meta_description="'.$manufacturers_meta_description.'", manufacturers_url="'.$manufacturers_url.'", email="'.$email.'")')
and mysql_query('UPDATE '.TABLE_MANUFACTURERS.' SET (manufacturers_image="'.$man_pic.'", last_modified="'.date('Y-m-d H:i:s').'")'))
{
$content='



';
}
else
{
$content='



';
}
}//main
//-------------------------------------------------------------------------------------------------------------------------------------------------------------------
echo $content;