1)?$_POST['odate']:'' ;
$updateSQL = sprintf("UPDATE order_express SET ocar=%s,odate=%s, pcar=%s, pcode=%s WHERE zid=%s",
GetSQLValueString($_POST['ocar'], "text"),
GetSQLValueString($odate, "date"),
GetSQLValueString($_POST['pcar'], "text"),
GetSQLValueString($_POST['pcode'], "text"),
GetSQLValueString($_POST['zid'], "int"));
mysql_select_db($database_BE2, $BE2);
$Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error());
$msg='更新完成!....' ;
$updateGoTo = "mysale.html";
echo "";
}
//update `member` set company_title=mem_name WHERE mem_auto>10 and mem_auto<26
//$currentPage ="mysale_eedit.html";//
$colname_Rt2 = "-1";
if (isset($_GET['id'])) {
$colname_Rt2 = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_BE2, $BE2);
// zid
$query_Rt2 = sprintf("SELECT a.*,b.mem_name,c.* FROM order_datam as a ,member as b, order_express as c WHERE a.duser=b.mem_auto AND a.dcode=c.dcode AND a.did='%s' ",$colname_Rt2); //,$colname_Rt2
// update order_tmp as a,product_data as b set a.coid=b.company_num where a.mem_auto=b.mem_auto
/* fix order_datam add companny id
//update order_datam as a,order_datas as b ,product_data as c set a.coid=c.company_num where a.dcode=b.dcode and b.mem_auto=c.mem_auto
*/
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
?>