[shiqla]

I ve problem with this codes.Im working with php & mySQL to build system inventory.So, i want it to be like this.When we sale product,it will reduce the amount that we store in stock record automatically.So, the record in stock record will always be updated automatically.So, we will know the quantity of stock in stock record.Pls help me dude!!!!May be you have another example or can help me to modify this codes.It cannot run,and gives error.

PHP Code:

<? 

include 'dbase.php';



$namaproduk=$_POST['namaproduk'];

$hargaseunit=$_POST['hargaseunit'];

$peratuskeuntungan=$_POST['peratuskeuntungan'];

$hargajualan=$_POST['hargajualan'];

$profit=$_POST['profit'];

$biljualan=$_POST['biljualan'];

$tarikh=$_POST['tarikh'];

$query = "INSERT INTO jualan VALUES('$namaproduk','$hargaseunit','$peratuskeuntungan','$hargajualan','$profit','$biljualan',NOW(),'')";

$result=mysql_db_query($dbname,$query);

$ques = "select bilJualan from jualan";

$rest = mysql_query($ques);

$bilJ = $row['bilJualan'];



$sqls = "select bilStok from stok";

$que = mysql_query($sqls);

$row = mysql_fetch_array($que);

$bilS = $row['bilStok'];



$total = $bilS - $_POST['biljualan'];



echo $total;



if($result){



$sql = "UPDATE stok set bilStok='$total'"



header("Location:rekodjualan.php");



}

?>