# View this please

**URL:** https://forum.kirupa.com/t/view-this-please/280393
**Category:** Uncategorized
**Created:** [January 27, 2009, 5:04am UTC](https://forum.kirupa.com/t/view-this-please/280393 "2009-01-27T05:04:50Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![saran](https://avatars.discourse-cdn.com/v4/letter/s/7ea924/32.png) [@saran](https://forum.kirupa.com/u/saran)
#### Post date: [January 27, 2009, 5:04am UTC](https://forum.kirupa.com/t/view-this-please/280393/1 "2009-01-27T05:04:50Z")

</div>

hi everbody…

i’ve an xml file like this stored in mysql database…

\<?xml version=“1.0” encoding=“iso-8854-1”?\>  
\<listings\>  
\<basicdetails available=“yes”\>  
\<title\>sale\</title\>  
\<make\>Audi\</make\>  
\<model\>a4\</model\>  
\<yearofmanufacture\>2006\</yearofmanufacture\>  
\<state\>2\</state\>  
\<city\>63\</city\>  
\<kilometersdriven\>5000\</kilometersdriven\>  
\</basicdetails\>  
\</listings\>  
\<?xml version=“1.0” encoding=“iso-8854-1”?\>  
\<listings\>  
\<basicdetails available=“yes”\>  
\<title\>sale\</title\>  
\<make\>bmw\</make\>  
\<model\>m-3\</model\>  
\<yearofmanufacture\>2005\</yearofmanufacture\>  
\<state\>4\</state\>  
\<city\>60\</city\>  
\<kilometersdriven\>50000\</kilometersdriven\>  
\</basicdetails\>  
\</listings\>  
…  
…

i wish to retrieve this using php…  
also i wish to store into the database under respective fields like title, make, model,etc.

help me to bring out this…:hurt: