''){
$ext= explode('.',$_FILES[$tfile]['name']) ;
$imgext=strtolower($ext[count($ext)-1]); //取最後一筆
$pic=$wwwpath.$picpath.".".$imgext;
$mem_logo=$imgext;
move_uploaded_file($_FILES[$tfile]["tmp_name"],$pic);
}
*///SELECT a.*,b.scode as bscode,b.mem_name as pname FROM member as a left join member as b on a.mem_num=b.mem_auto WHERE a.mem_auto = 262
/*
$updateSQL = sprintf("UPDATE member SET mem_num=%s, mem_mail=%s, mem_name=%s, mem_code=%s, m_bankcode=%s, m_bankname=%s,m_bank=%s,m_bank2=%s,
m_pic1=%s, m_pic2=%s, m_pic4=%s,creditcard=%s,payername=%s,payermobile=%s,payermail=%s WHERE mem_auto=%s",
GetSQLValueString($_POST['mem_num'], "int"),
GetSQLValueString($_POST['mem_mail'], "text"),
GetSQLValueString($_POST['mem_name'], "text"),
GetSQLValueString($_POST['mem_code'], "text"),
GetSQLValueString($_POST['m_bankcode'], "text"),
GetSQLValueString($_POST['m_bankname'], "text"),
GetSQLValueString($_POST['m_bank'], "text"),
GetSQLValueString($_POST['m_bank2'], "text"),
GetSQLValueString($m_pic1, "text"),
GetSQLValueString($m_pic2, "text"),
GetSQLValueString($m_pic4, "text"),
GetSQLValueString($_POST['creditcard'], "text"),
GetSQLValueString($_POST['payername'], "text"),
GetSQLValueString($_POST['payermobile'], "text"),
GetSQLValueString($_POST['payermail'], "text"),
GetSQLValueString($_SESSION['login_memid'], "int"));
*/
$updateSQL = sprintf("UPDATE member SET mem_num=%s, mem_mail=%s, mem_name=%s, mem_code=%s,
creditcard=%s,payername=%s,payermobile=%s,payermail=%s WHERE mem_auto=%s",
GetSQLValueString($_POST['mem_num'], "int"),
GetSQLValueString($_POST['mem_mail'], "text"),
GetSQLValueString($_POST['mem_name'], "text"),
GetSQLValueString($_POST['mem_code'], "text"),
GetSQLValueString($_POST['creditcard'], "text"),
GetSQLValueString($_POST['payername'], "text"),
GetSQLValueString($_POST['payermobile'], "text"),
GetSQLValueString($_POST['payermail'], "text"),
GetSQLValueString($_SESSION['login_memid'], "int"));
mysql_select_db($database_BE2, $BE2);
$Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error());
$msg='更新完成....' ;
$updateGoTo = "editprofile.html";
echo '';
}
//update `member` set company_title=mem_name WHERE mem_auto>10 and mem_auto<26
mysql_select_db($database_BE2, $BE2);
$query_Rt2 = sprintf("SELECT a.*,b.scode as bscode,b.mem_name as pname FROM member as a left join member as b on a.mem_num=b.mem_auto WHERE a.mem_auto = %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);
mysql_select_db($database_BE2, $BE2);
$query_Rt3 = "SELECT * FROM creditcard order by pp1" ;
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);
//creditcard
// echo $query_Rt2;
?>