209684 Spider RSS feed MySql content

Spider and Database Project I have a NEW project that I require the following You need to write a spider that can extract RSS Feeds from a specific site. The RSS Feeds only have a few fields and the fist few lines of the news release. After getting the complete RSS list you will need to spider the balance of each release and the content will need to be stored into a MySQl dbase. I have created the dbase already and the data needData from that site needs to be spidered and then entered into a MySql database. The database needs to have the data so I can query the database. The site I am looking to source news data are: 1. Yahoo news 2. P r w eb . com 3. ma rket wire . c om 4. [login to view URL] I am looking for 1 site to be done first, then the next and so on until all 4 sites have been spidered and then all 4would be done daily going forward. ============================================== PLEASE BID ON ONLY 1 SOURCE OF NEWS TO SPIDER. ============================================== Winning bidder will likely win all 4 projects but I need 1 Spider completed ASAP I require that all spidered data be in a single database where I can select to include or exclude it from the finished page. So the script must run once a day and add only the new pages into the database. Please send examples in Private message. Once I have selected the data from the database you will need to have a resulting html page that has all the selected news releases on a single page. Each day there will be a new page and the previous page will be left on the server. The fields required are Source: Logo Image: Time: Date: Headline: Summary Paragraph: Message/Release Body: About Company: Conatct: Name, Title, Company, Address, Tel, Fax, Mobile, email, website ========================= Here is a sample HTML format ========================= Sample 1: http://www. m a r k e t w i..r.e...co.m./m.w/[login to view URL] (remove spaces and .) Sample 2: http://www.b.us.iness...wi.r.e.co.m/portal/site/home/[login to view URL];newsId=2008 0321005074&ndmHsc=v2*A1203685200000*B1206354770000*DgroupByDate*J2*M31337*N 1009164&newsLang=en&beanID=383539599&viewID=news_view (remove spaces and .) ========================= Here is a sample release in text format ========================= FOR IMMEDIATE RELEASE CONTACT Contact Person Company Name Voice Phone Number FAX Number Email Address Website U R L XYZ, Inc. Announces Widget to Maximize Customer Response Rate This headline is one of the most important components of the press release as this needs to grab the attention of the editor. It should be in bold type and a font that is larger than the body text. Preferred type fonts are Arial, Times New Roman, or Verdana. Keep the headline to 80-125 characters maximum. Capitalize every word with the exception of a , the an or any word that is three characters or less. (City), (State), (Date) - Your first paragraph of the release should be written in a clear and concise manner. The opening sentence contains the most important information keep it to 25 words or less. Never take for granted that the reader has read your headline. It needs contain information that will entice the reader. Remember, your story must be newsworthy and factual don't make it a sales pitch or it will end up in the trash. Answer the questions who , what , when , where , why and how . Your text should include pertinent information about your product, service or event. If writing about a product, make sure to include details on when the product is available, where it can be purchased and the cost. If you're writing about an event, include the date, location of the event and any other pertinent information. You should include a quote from someone that is a credible source of information include their title or position with the company, and why they are considered a credible source. Always include information on any awards they have won, articles they've published or interviews they have given. Keep your sentences and paragraphs short a paragraph should be no more than 3-4 sentences. Your release should be between 500 to 800 words, written in a word processing program, and spell checked for errors. Don't forget to proofread for grammatical errors. The mood of the release should be factual, not hyped don't use a sales pitch as it will ruin your credibility with the reader. The last paragraph before the company information should read for additional information on (put in the subject of this release), contact name or site-here. If you offer a sample, copy or demo, put the information in here. You can also include details on product availability, trademark acknowledgment, etc. in this area of the release. ABOUT (COMPANY) - Include a brief description of your company along with the products and services it provides. - END - At the end of the release, you need to indicate that the release is ended. This lets the journalists know they have received the entire release. Type End on the first line after your text is completed. If your release goes over one page, type MORE at the bottom of the first p