Android (PHP/MySQL) สอบถาม SELECT * FROM user WHERE 1 AND Name LIKE....

<?
require_once("connectPHP.php");
	
	// $_POST["txtKeyword"] = "a"; // for Sample

	$strKeyword = $_POST["txtKeyword"];
	$strSQL = "SELECT * FROM user WHERE 1 AND Name LIKE '%".$strKeyword."%'  ORDER BY ID ASC  ";

	$objQuery = mysql_query($strSQL);
	$intNumField = mysql_num_fields($objQuery);
	$resultArray = array();
	while($obResult = mysql_fetch_array($objQuery))
	{
		$arrCol = array();
		for($i=0;$i<$intNumField;$i++)
		{
			$arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];
		}
		array_push($resultArray,$arrCol);
	}

	
	mysql_close($objConnect);
	
	echo json_encode($resultArray);
?>