<?php require_once('../Connections/BE2.php'); ?>
<?php
 
$scode = "-1";
if (isset($_POST['pname'])) {
  $scode = $_POST['pname'];
}
mysql_select_db($database_BE2, $BE2);
$query_Rtd = sprintf("SELECT * FROM member WHERE scode = '%s'", $scode  );
$Rtd = mysql_query($query_Rtd, $BE2) or die(mysql_error());
$row_Rtd = mysql_fetch_assoc($Rtd);
$totalRows_Rtd = mysql_num_rows($Rtd);
 
$result = array();

if($totalRows_Rtd>0){
 $result['id'] = $row_Rtd['mem_auto'];
 $result['name'] = $row_Rtd['scode'];
} else{
 $result['id'] = "1";
 $result['name'] = "";	
 }


echo json_encode($result);
 


mysql_free_result($Rtd);
?>