Page 1 of 1

How to do this?

Posted: Mon Nov 03, 2008 10:33 am
by Abu-Dina
Greetings all! :oops:

Please firgive me for asking such a n00b question but your help with this would be greatly appreciated!

I have a database table made up of the following columns:

DVD_Title, Release_Date, Price

At the moment, the table contains just the title and release date. What I want to do is to take each title, search the following website: http://www.find-dvd.co.uk and retrieve the cheapest price (the cheapest price is displayed when the search is done on the website)

I would then like to update my table with that price.

How can I do this?

Any advise, sample code would be so much help to me.

Thanks.

Re: How to do this?

Posted: Mon Nov 03, 2008 10:37 am
by JayBird
Do you have permission to get the prices from that site?

Re: How to do this?

Posted: Mon Nov 03, 2008 10:45 am
by Abu-Dina
No I don't have permission. I suppose I could contact them but then I'm not planning to start my own comparison website. I have no intention of doing so. All I want is the ability to find the cheapest price without doing a manual search.

Re: How to do this?

Posted: Mon Nov 03, 2008 10:50 am
by JayBird
You would need to scrape their website, which i guess would be against their terms and conditions...
None of the content may be downloaded, copied, reproduced, transmitted, stored, sold or distributed without the prior written consent of the copyright holder.
So this would make it illegal, and hence we won't discuss it here

Re: How to do this?

Posted: Mon Nov 03, 2008 10:57 am
by Abu-Dina
JayBird wrote:You would need to scrape their website, which i guess would be against their terms and conditions...
None of the content may be downloaded, copied, reproduced, transmitted, stored, sold or distributed without the prior written consent of the copyright holder.
So this would make it illegal, and hence we won't discuss it here
Okay that's fair enough. So am I stuck with the manual route?! oh well... that or contact all these online retailers for their price list!