<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	//echo "abc";
	
	if(isset($_GET['id']) && isset($_GET['show'])){
		$id=$_GET['id'];
		$sql="SELECT * FROM  `asnd` WHERE  `ID` =$id";
		$result=mysql_query($sql,$dbc);
		
		$totalRow=mysql_num_rows($result);
		if($totalRow>0){
			$table1='<table border="1" cellpadding="0" cellspacing="0" width="1024">';
			$table1=$table1.'
			<tr>
				<td>nID</td><td>ID</td><td>ASNID</td><td>ITEMNO</td>
				<td>SKU</td><td>SKUCN</td><td>SKUEN</td><td>VEDCODE</td><td>UOM</td>
				<td>UOMNUM</td><td>FDUNIT</td><td>TWEIGHT</td><td>UNITWEIGHT</td>
				<td>SKUN</td><td>CUSTMITEM</td><td>COO</td>
				<td>UNITPRICE</td><td>TPRICE</td><td>LOC</td>
			</tr>
			';
			while($row_Rec=mysql_fetch_assoc($result)){
				$table1=$table1.'<tr>
					<td>'.$row_Rec['nID'].'</td>
					<td>'.$row_Rec['ID'].'</td>
					<td>'.$row_Rec['ASNID'].'</td>
					<td>'.$row_Rec['ITEMNO'].'</td>
					<td>'.$row_Rec['SKU'].'</td>
					<td>'.$row_Rec['SKUCN'].'</td>
					<td>'.$row_Rec['SKUEN'].'</td>
					<td>'.$row_Rec['VEDCODE'].'</td>
					<td>'.$row_Rec['UOM'].'</td>
					<td>'.$row_Rec['UOMNUM'].'</td>
					<td>'.$row_Rec['FDUNIT'].'</td>
					<td>'.$row_Rec['TWEIGHT'].'</td>
					<td>'.$row_Rec['UNITWEIGHT'].'</td>
					<td>'.$row_Rec['SKUN'].'</td>
					<td>'.$row_Rec['CUSTMITEM'].'</td>
					<td>'.$row_Rec['COO'].'</td>
					<td>'.$row_Rec['UNITPRICE'].'</td>
					<td>'.$row_Rec['TPRICE'].'</td>
					<td>'.$row_Rec['LOC'].'</td>
				</tr>';
			}			
			$table1=$table1.'</table>';			
			//echo $table1;
			$obj->result=1;
			$obj->status=1;
			$obj->table=$table1;
			$obj->reasons="load Detail complete";
			echo json_encode($obj);			
		}else{
			$obj->result=0;
			$obj->status=0;
			$obj->reasons="No Detail Info";
			echo json_encode($obj);
		}		
		return;
	}
/**
nID	ID	ASNID	ITEMNO	SKU	SKUCN	SKUEN	VEDCODE	UOM	UOMNUM	FDUNIT	TWEIGHT	UNITWEIGHT	SKUN	CUSTMITEM	COO	UNITPRICE	TPRICE	LOC
*/	
?>