Hi Nox,
I have just started learning php with a MySQL database as well. I have just started building a dynamic website for a business although they don't want an xml export.
All the pages data is pulled up from the database which i wrote my own administration section for. I even have a table for the site settings (eg: colours, background pics., etc.)
With the xml export you could run a database query which will pull the data out of the database then run a loop though the records and for each row you could append to the xml file.
Code:
// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
//select the database
mysql_select_db($dbname) or die('Cannot select database');
//Select the data
$query = "SELECT * FROM pages";
//Run the query
$result = mysql_query($query) or die(mysql_error());
//Open file but for appending
$openfile = @fopen($file,"a");
//Write the xml headers
@fwrite($openfile, '<?xml version="1.0" encoding="iso-8859-1" ?> ');
//Loop through the results and output the data
while($row = mysql_fetch_array($result))
{
//For each coloumn in each row write the data out
//Following will only write ONE row of data
@fwrite($openfile, "<pagename>".$row['pagename']."</pagename>");
//etc.
}
//Write the footers (if any)
@fwrite($openfile, "");
//Close the file
fclose ($openfile);
Of course I have left out any error checking but this is the general idea. Let me know if you want any more help.