用php和mysql做的仓库管理系统，我想将传递过来的数据进行判断，商品已存在的数量相加，不存在的直接插入

$a=mysql_query("select * from tb_kucun where spname='$spname'")

$result=mysql_query($a)

if(!mysql_num_rows($result)){

$sql="insert into tb_kucun (spname,dj,dw,kcsl,ckname,sup) values ('$spname','$dj','$dw','$sl','$rkname','$sup')"

mysql_query($sql)

}

else{

$c = "UPDATE tb_kucun SET kcsl = kcsl+'{$sl}' WHERE spname = '{$spname}'"

mysql_query($c)

}

The statistical data warehouse plays an important role of the development of the company in the decision. Customer files management, information management, commodity sales management, inventory management, purchase management manual is low efficiency that can't adapt to the needs of the development of the company. Existing warehouse system has achieved sales of commodities, stock, inventory data stores various statistical data, thereby significantly reducing the data of circulation and increasing the reliability of the data

The warehouse management system by means of information and the introduction of advanced enterprise management method for the practice of enterprise,which provide a feasible approach to the enterprise's management reform . More importantly, warehouse management system can change timely the enterprise data into enterprise information through information technology , and provide decision basis for related managers.

This system is aim at medium commodity trading company purchase, sales and stock in manual operation for major basically management at present , informationization level is very low, and design the goods warehouse management system. The main function of the purchase of goods is monitored, sales and inventory management, and realize the goods warehouse management informationization, automation and scientific. This system is a stand-alone database management system.The application interfaces use eclipse to develop it, the backend database of the system chooses MySQL5.0 as a development tool

---