$_POST['company_title']){
mysql_select_db($database_BE2, $BE2);
$query_Rtc = sprintf("SELECT * FROM company WHERE company_title = %s", GetSQLValueString($_POST['company_title'], "text"));
$Rtc = mysql_query($query_Rtc, $BE2) or die(mysql_error());
$row_Rtc = mysql_fetch_assoc($Rtc);
$totalRows_Rtc = mysql_num_rows($Rtc);
if($totalRows_Rtc==0){
// make logo
$_GET['shopname']=trim($_POST['company_title']) ;
$_GET['shopid']=$_SESSION['login_memid'] ;
//include('mk_webshop_logo.php');
}else{ $check_title=1; }
mysql_free_result($Rtc);
}
if($check_title==0){
//com_express com_express_
$updateSQL = sprintf("UPDATE company SET company_line=%s, company_title=%s, company_address=%s, company_mail=%s, company_tel=%s WHERE coid=%s",
GetSQLValueString($_POST['company_line'], "text"),
GetSQLValueString($_POST['company_title'], "text"),
GetSQLValueString($_POST['company_address'], "text"),
GetSQLValueString($_POST['company_mail'], "text"),
GetSQLValueString($_POST['company_tel'], "text"),
GetSQLValueString($_POST['coid'], "int")); //$_SESSION['login_memid']
mysql_select_db($database_BE2, $BE2);
$Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error());
$msg='更新完成....' ;
}else{ $msg='公司名稱重複....' ; }
$updateGoTo = "webshopdev.html";
echo '';
}
mysql_select_db($database_BE2, $BE2);
$query_Rt2 = sprintf("SELECT * FROM company WHERE mid = %s", GetSQLValueString($_SESSION['login_memid'], "int"));
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
$company_coid=$row_Rt2['coid'];
$q_up1 = sprintf("UPDATE member set coid='%s' WHERE coid = 0 AND mem_auto='%s' ", $company_coid, $_SESSION['login_memid']);
mysql_query($q_up1, $BE2) or die(mysql_error());
$img2='/www2/skybni/shop/ext/elogo_'.sprintf('%07d', $company_coid ).".png";
if(! file_exists($img2)){
// $_GET['shopname']= '開發商網店';
$_GET['shopid']=$company_coid;
include 'mk_webshopdev_logo2.php';
}
// echo $q_up1;
/*
mysql_select_db($database_BE2, $BE2);
$query_Rt3 = sprintf("SELECT * FROM webshop WHERE coid= 1 OR coid='%s' order by coid,windex",$_SESSION['login_memid']) ;
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);
$arr1=array();
$i=0;
do {
if($row_Rt3['coid']>1){ $i=$row_Rt3['windex']-1;}
$arr1[$i][0]=$row_Rt3['wid'];
$arr1[$i][1]=$row_Rt3['coid'];
$arr1[$i][2]=$row_Rt3['wtitle'];
$arr1[$i][3]=$row_Rt3['wimg'].'.'.$row_Rt3['wimgext'];
$arr1[$i][4]=$row_Rt3['wlink'];
$arr1[$i][5]=$row_Rt3['wuse']; // can edit upload
$arr1[$i][6]=$row_Rt3['wflag']; // can edit upload
$i++;
} while ($row_Rt3 = mysql_fetch_assoc($Rt3));
*/
?>