一个网上理财站点的设计（九）

CREATE TABLE in_ex_condition (
code bigint DEFAULT '0' NOT NULL auto_increment,/*编码*/
in_ex_type bigint NOT NULL,/*收支项目*/
user char(12) NOT NULL,/*用户*/
account bigint NOT NULL,/所属帐户*/
date date NOT NULL,/*发生日期*/
money decimal(15,2) NOT NULL,/*金额*/
balance decimal(15,2) NOT NULL,/*余额*/
account_contrary bigint NULL,/*转出、转入的相应帐户*/
comment varchar(40) NULL,/*简要说明*/
PRIMARY KEY (code))

if ($res)
{echo "<script language='JavaScript'>";
echo "alert('帐户建立成功');";
echo "parent.location.href='account.php'";
echo "</script>";}
else {
echo "<script language='JavaScript'>";
if ($res)
{//得到刚插入的帐户的code
$query = "select code from account where user='".$cookie_user."'
order by code DESC"; 
$res = mysql_query($query); 
$row = mysql_fetch_array($res);
//将对应帐户中的转出记录的account_contrary置值
$query="update in_ex_condition set account_contrary=".$row['code'].
" where user='".$cookie_user."' and account_contrary=0";
$res = mysql_query($query); 
echo "<script language='JavaScript'>";
echo "alert('帐户建立成功');";
echo "parent.location.href='account.php'";
echo "</script>";}
else {
//得到刚插入的转出记录的code
$query="select code from in_ex_condition where user='".$cookie_user."' 
and account_contrary=0";
$res = mysql_query($query); 
$row = mysql_fetch_array($res);
//删除对应帐户中的转出记录
include ("function_account_delete.php");
account_delete($row['code'])
echo "<script language='JavaScript'>";

if ($this_type==1)
$query = "INSERT INTO in_ex_condition
(in_ex_type,user,account,date,money,balance) 
VALUES (".$in_ex_type.",'".$user."',".$account.",'"
.$date."',".$money.",".$this_balance."-".$money.")";
else
$query = "INSERT INTO in_ex_condition 
(in_ex_type,user,account,date,money,balance) 
VALUES (".$in_ex_type.",'".$user."',".$account.",'"
.$date."',".$money.",".$this_balance."+".$money.")";
$res = mysql_query($query); 
return 1;}
改为：
//增添收支情况中记录
if ($this_type==1)
$query = "INSERT INTO in_ex_condition
(in_ex_type,user,account,date,money,balance,account_contrary,comment) 
VALUES (".$in_ex_type.",'".$user."',".$account.",'".$date."',"
.$money.",".$this_balance."-".$money.",".$account_contrary".,'"
.$comment."')";
else
$query = "INSERT INTO in_ex_condition (in_ex_type,user,account,
date,money,balance,account_contrary,comment) 
VALUES (".$in_ex_type.",'".$user."',".$account.",'".$date."',"
.$money.",".$this_balance."+".$money.",".$account_contrary".,'"
.$comment."')";
$res = mysql_query($query); 
return 1;}