'')){ $mspic=trim($_POST['set2']); }
if($_FILES[$tfile1]["name"]<>''){
$ext1= explode('.',$_FILES[$tfile1]['name']) ;
$imgext1=strtolower($ext1[count($ext1)-1]); //取最後一筆
if(in_array($imgext1,$img_ext_array)){
$mspic='ma'.date('YmdHis').sprintf("%04d",rand(1,9999)).'.'.$imgext1;
$pic1=$imgpath.$mspic;
move_uploaded_file($_FILES[$tfile1]["tmp_name"],$pic1);
}else{ $write='圖檔錯誤...'; }
}
if($_POST['msid']==0){
$updateSQL = sprintf("INSERT INTO marketmaster(msname,mspic,mslink)VALUES(%s,%s,%s )",
GetSQLValueString($_POST['msname'], "text"),
GetSQLValueString($mspic, "text"),
GetSQLValueString($_POST['mslink'], "text"));
}else{
$updateSQL = sprintf("UPDATE marketmaster set mspic=%s,mslink=%s where msid='%s'",
GetSQLValueString($mspic, "text"),
GetSQLValueString($_POST['mslink'], "text"),
GetSQLValueString($_POST['msid'], "int") );
}
mysql_select_db($database_BE2, $BE2);
mysql_query($updateSQL, $BE2) or die(mysql_error());
// echo $upSQL;
$updateGoTo =$_POST['url'];
echo "";
}
$msid=0;
if (isset($_GET['msid'])) {
$msid = $_GET['msid'];
}
$key='';
if (isset($_GET['key'])) {
$key = $_GET['key'];
}
if($msid>0){
mysql_select_db($database_BE2, $BE2);
// address_id county district street
$query_Rt2 = sprintf("SELECT * FROM marketmaster where msid='%s' order by msid limit 1 ",$msid);;
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
$key=$row_Rt2['msname'];
}
?>
0){ mysql_free_result($Rt2);}
?>
