Query Problem[SOLVED]
Posted: Fri Aug 24, 2007 9:54 am
I have a problem with my query, i must have some structure wrong here but i cannot see where i have gone wrong... can any one see where i have gone wrong ?
Code: Select all
$GetHouses = mysql_query("SELECT houses.*, cities.*, countries.* FROM houses, cities, countries WHERE houses.userID ='{$_SESSION['Current_User']}' AND cities.cityID = houses.cityID AND cities.countryID = countries.countryID.") or die(mysql_error());