<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	$holdLoc="";
	if(!isset($_SESSION)){
		session_start();
	}	
	//echo "abc";	
	if(isset($_POST['location'])){
		//echo $_POST['location'];
		$holdLoc=$_POST['location'];
		$sql="UPDATE `lotxloc` INNER JOIN `loc` ON `lotxloc`.`LOC` = `loc`.`LOCCODE` 
			SET `lotxloc`.`isHold` = '1', `loc`.`LOCATTR` = 'OnHold' 
			WHERE `lotxloc`.`LOC` = '$holdLoc'";
		//echo $sql;
		mysql_query($sql,$dbc);		
		$obj->status=1;
		$obj->result=1;
		$obj->reason="Location Hold Complete";
		//$obj->sql=$sql;
		echo json_encode($obj);
		return;
	}	
/*
UPDATE `lotxloc` INNER JOIN `loc` ON  
`lotxloc`.`LOC` = `loc`.`LOCCODE` 
SET `lotxloc`.`isHold` = '1', `loc`.`LOCATTR` = 'OnHold' 
WHERE `lotxloc`.`LOC` = 'bbb'
*/	
?>