Reducing stock automatically when sale product!!!!

[inventive]

<? 
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','$peratuskeunt  ungan','$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"); 

} 
?> 

[leatherback]

And for us dummies who cannot read you mind..

What is the magic question? Where is the problem? What are you asking us to do for you?

j.

[inventive]

Im very sorry.Accidentally,ive deleted my question yesterday.This is my question...So sorry...

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.

[leatherback]

Hi,

How do you work with this system?

In general, what you need to do:

update TABLE_NAME set NUMBERS_IN_STOCK_COLUM = NUMBERS_IN_STOCK_COLUM-1 where PRODUCTIDENTIFIER = $SOLDPRODUCT

Or, you could make the 1 a variable, and pass the number of items sold through that variable.

J.

SOrry: Would love to elaborate, but am actually trying to get some code to work myself..