<?php
	header('Content-type: text/html; charset=utf-8');
	
	require_once('connDB.php');
	
	if(!isset($_SESSION)){
		session_start();
	}
		
	$sql="SELECT  `sku`.*,  `cust`.`custcn` ";
	$sql=$sql."FROM  `sku`  LEFT JOIN `cust` ON 
			`sku`.`custid` = `cust`.`custid`
			ORDER BY `sku`.id DESC; ";
	
	$result = mysql_query($sql,$dbc);
	//$row_Rec = mysql_fetch_assoc($result);
	//echo $row_Rec['id'];
	$Arr1 = Array();
	$total_Row=mysql_num_rows($result);
	
	while($row_Rec=mysql_fetch_assoc($result)){
		$Arr2=array("id"=>$row_Rec['id'],
					"custid"=>$row_Rec['custid'],
					"custcn"=>$row_Rec['custcn'],
					"skuid"=>$row_Rec['skuid'],
					"skucn"=>$row_Rec['skucn'],
					"skuen"=>$row_Rec['skuen'],
					"customs"=>$row_Rec['customs'],
					"uom"=>$row_Rec['uom'],
					"nw"=>$row_Rec['nw'],
					"unit"=>$row_Rec['unit'],
					"custm"=>$row_Rec['custm'],
					"jgtj"=>$row_Rec['jgtj'],
					"custn"=>$row_Rec['custn'],
					"sbys"=>$row_Rec['sbys'],
					"remark"=>$row_Rec['remark']);
		array_push($Arr1,$Arr2);
	}
	$obj->total = $total_Row;
	$obj->rows = $Arr1;
	echo json_encode($obj);

?>