How to generate a file xml since several tables from mysql database using php?

[Fire Zone]

I want to generate xml file from several tables in a MySQL database using PHP.\[code\]$query = "SELECT t.value, d.value, ty.value, p.id, p.ref, p.is_renting, p.price, p.adress, p.living_space, p.roomsFROM jos_jea_properties pINNER JOIN jos_jea_towns tON t.id = d.town_id INNER JOIN jos_jea_departments d ON d.id = p.department_id INNER JOIN jos_jea_types ty ON ty.id = p.type_id";$result = mysql_query ($query, $link) or die("Could not complete database query"); \[/code\]But, it show me Could not complete database query, have you any idea?