How to do this?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
Abu-Dina
Forum Newbie
Posts: 3
Joined: Wed Oct 22, 2008 10:23 am

How to do this?

Post 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.
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Re: How to do this?

Post by JayBird »

Do you have permission to get the prices from that site?
Abu-Dina
Forum Newbie
Posts: 3
Joined: Wed Oct 22, 2008 10:23 am

Re: How to do this?

Post 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.
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Re: How to do this?

Post 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
Abu-Dina
Forum Newbie
Posts: 3
Joined: Wed Oct 22, 2008 10:23 am

Re: How to do this?

Post 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!
Post Reply