php mysql db select json print

jquery ajax사용시 db에서 조회해서 json으로 가져오기

<?
	//db connect..

	$query = "SELECT REG_NO, CTG_NAME FROM CATEGORY_INFO
				 ORDER BY CTG_ORDER, REG_NO";

	$return_array = array();
	$result = mysql_query($query);

	while ($row = mysql_fetch_array($result)){
		$row_array['REG_NO'] = $row['REG_NO'];
		$row_array['CTG_NAME'] = $row['CTG_NAME'];

		array_push($return_array, $row_array);
	}

	echo json_encode($return_array);

	//db close..
?>