I'm having some troubles to export my data from my DB, im using phpmyadmin and i want to export alot of data but i wanted in dat way

<stuff>
<id>111</id>
<country>USA</country>
<photos>
<photo>http:www.photo1.com</photo>
<photo>http:www.photo2.com</photo>
<photo>http:www.photo3.com</photo>
</photos>

<id>222</id>
<country>USA</country>
<photos>
<photo>http:www.photo12.com</photo>
<photo>http:www.photo22.com</photo>
<photo>http:www.photo32.com</photo>
<photo>http:www.photo42.com</photo>
<photo>http:www.photo52.com</photo>
</photos>
...
</stuff>

i have a db with 7 tables all related to one with the id and i dont know if i have to create a sigle table without realations (i dont think thats a good idea because i dont know how i can put all the photos in one field)

i tried to export the data with the export option of myphpadmin but i cant select how i want the data to be exported like and its exported only table by table

<stuff>

<table name="identification">

<column name="id">111</column>
<column name="contry">USA</column>
</table>

<table name="identification">

<column name="id">222</column>
<column name="contry">USA</column>
</table>

<table name="photos">

<column name="photo">http:www.photo1.com</column>
<column name="photo">http:www.photo2.com</column>
<column name="photo">http:www.photo3.com</column>
</table>


<table name="photos">

<column name="photo">>http:www.photo12.com</column>
<column name="photo">http:www.photo22.com</column>
<column name="photo">http:www.photo32.com</column>
<column name="photo">http:www.photo42.com</column>
<column name="photo">http:www.photo52.com</column>

</table>
</stuff>


PD: sorry about my writting but english is not my native language

Maybe you can create a view of the data with WHERE clause, GROUP BY, ORDER BY and then export the view with phpMyAdmin? This way you have some access to the structure the xml will have.

cheers, j

tx a lot but i allready tried that but the problem is that i need all the photos together and in that way i get a lot of rows like these

<stuff>
<table name="identification">
<column name="id">111</column>
<column name="contry">USA</column>
<photo>http:www.photo1.com</photo>
</table>

<table name="identification">
<id>111</id>
<country>USA</country>
<photo>http:www.photo2.com</photo>
</table>

<table name="identification">
<column name="id">111</column>
<column name="contry">USA</column>
<photo>http:www.photo3.com</photo>
</table>

<table name="identification">
<column name="id">111</column>
<column name="contry">USA</column>
<photo>http:www.photo12.com</photo>
</table>
...
</stuff>


and when i make the group by i only get one photo and i loose the other ones

solved:
the solution i made was with a script in php like these
<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "admin";
$dbname = "test";
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);


$sql = "SELECT * FROM books";
$q = mysql_query($sql) or die(mysql_error());
$xml = "<library>";
while($r = mysql_fetch_array($q)){
$xml .= "<book>";
$xml .= "<id>".$r['id']."</id>";
$xml .= "<title>".$r['title']."</title>";
$xml .= "<author>".$r['author']."</author>";
$xml .= "<description>".$r['description']."</description>";
$xml .= "<on_sale>".$r['on_sale']."</on_sale>";
$xml .= "</book>";
}
$xml .= "</library>";
$sxe = new SimpleXMLElement($xml);
$sxe->asXML("test.xml");

?>

from: http://www.phpeveryday.com/articles/...base-P534.html