Hai
  Can you please tell me in detail how i can do this.
  Because i am new to PHP.
 
<?xml version="1.0" encoding="UTF-8"?>
<Data>
<ResultCode>1000</ResultCode>
<Result>ProductID not found</Result>
<ProductID>GR100</ProductID>
<Sort></Sort>
<Category></Category>
<Title></Title>
<Stock>100</Stock>
</Data>

I need to store product id and stock in mysql.
Please help me.

regards
vidya
  
  
> Hi vidya,
> 
> I just wrote a program that does exactly that.  I used the PEAR XML 
Parser
> (usually found under /usr/local/lib/php/XML).
> 
> Keep in mind that you'll have to do a lot of background work before you
> start coding.  XML data are inherently hierarchical in structure.  MySQL
> data are relational in structure.  Therefore you will first have to map 
out
> a relational schema that can accurately store the data.
> 
> Are you using an XML Schema?
> 
> 
> -- Christopher
> 
> 
> 
> 
> On 2001.12.18 13:11 vidya wrote:
> > 
> > I have a XML document.
> > 
> > I want to insert the data from XML document into MySQL tables. Is 
there 
> > any way I can do this? If yes
> > 
> >  Please let me know with an example.
> > 
> > regards
> > vidya
> >