Whats wrong in this .php file.

[jatinkumar patel]

I am new to Php, so i am unable to find out the mistake i made.
Thanks for help.

<?PHP

$COUNTRY=$_POST['country'];
$STATE=$_POST['state'];
$CITY=$_POST['city'];

print ($COUNTRY);
print ($STATE);
print ($CITY);

mysql_connect("localhost:3306", "username", "password");
mysql_select_db("countries");

$result = mysql_query("SELECT hm.homeId, hm.addressHome, hm.Availability, hm.rent
	FROM cities ct, countries cs, states st, homes hm
	WHERE cs.countryId = st.countryId
	AND st.stateId = ct.stateId
	AND ct.cityId = hm.cityId
	AND cs.countryId =1
	AND st.stateId =1
	AND ct.cityId =1
	AND cs.countryName =  $COUNTRY
	AND st.stateName =  $STATE
	AND ct.cityName =  $CITY
LIMIT 0 , 30");

echo "<?xml version=\"1.0\" ?><homes>";

if ($returned_rows == 0){
	echo 'No records found';
}else{
	while($row = mysql_fetch_array($result)){
		echo "<home><id> . $row['homeId'] . </id>";
		echo "<address> . $row['addressHome'] . </address>";
		echo "<availability> . $row['Availability'] . </availability>";
		echo "<rent> . $row['Rent'] . </rent></home>";
		}
}
echo "</homes>";
?>

[Paul Clapham]

What makes you think there is anything wrong with it? (Read this: TellTheDetails)

[Rafael Monteiro Dourado]

in line 28 write :

$returned_rows = mysql_num_rows($result);