The scenario is this - I want to parse data from a website called
abc.com & automatically insert into mySql database in
123.com - both are owned by the same company but hosted at 2
different places. abc.com is directly connected to the back-end
inventory - which is provided thru the host.I have full control over
123.com. What I want to do is: say
x is a product in both the sites - i want to parse data like
availability & price of x from abc.com & store it in 123's
mysql say  as often as 24 hrs - so that the data(just the price &
availability) is
refreshed regularly without me having to do it manually. Is there a
way I can do this? - the common factor for these products is the
product_id there are about 1800 products in total. I am good in ASP -
I can understand a bit of Php too.I hope someone can help me with
this. Thank
you in advance

Assuming you are getting the data as HTML files via HTTP, the best bet
is going to be Perl with LWP.  However, you don't mention that you are
familiar with Perl, so I will let this one go.

Other options:  Does abc.com use XML to generate their webpage?  Can
abc.com make a text file or RDF file for you to read to insert into
123.com?

wengland hit the nail on the head :-)

A few more ideas of what you are capable of on the server side may
help us to help you better.

If you are able to generate the text/rdf file with the abc.com, I
would be able to help you implement this with PHP via HTTP socket,
much like wengland would offer a solution using Perl.

Let us know if you are able to install/use any of these ideas.

Thanks
SgtCory

I will learn perl if neccessary!..it will helpful if you can get me a
sample code where I can change few things to customize it. I am
definitely going to call the data as HTML files via HTTP. no! I am
sure that the abc.com does not use XML to generate their webpages.
they are small host company, I checked their admin console for
abc.com.

 I am very much interested to learn about perl with LWP..I am
listening.

I will learn perl if neccessary!..it will helpful if you can get me a
sample code where I can change few things to customize it. I am
definitely going to call the data as HTML files via HTTP. no! I am
sure that the abc.com does not use XML to generate their webpages.
they are small host company, I checked their admin console for
abc.com.

 I am very much interested to learn about perl with LWP..I am
listening wengland-ga.