<?php 
ob_start();
require_once("includes/dbsmain.inc.php");
include("site-main-query.php");
$site_url=$compDATA['admin_website_url'];

$qty=$_POST['qty_value'];
$id=$_POST['pro_id'];
$product_id=db_scalar("select bskt_prd_id from tbl_basket where 1 and bskt_id='$id' ");
$db_qty=db_scalar("select category_qnty from tbl_category where category_id='$product_id' ");

if($db_qty>=$qty)
{
   $procost=db_scalar("select bskt_prd_unit_price from tbl_basket where 1 and bskt_id='$id'");
   
    $total_cost=$qty*$procost;
    $update=db_query("update tbl_basket set bskt_prd_subtotal='$total_cost', bskt_prd_qnty='$qty' where 1 and bskt_id='$id'");
	//echo "$prd_id";
	//echo $total_cost;
	echo "updated";
}else
{
   // echo "Here is only ".$db_qty." left in stock, please enter equal or below ".$db_qty." !";
   echo "not available";
}


?>