I am trying to figure a simple way of creating a script for a news site to recommend articles that are similar [i.e. about the same company]
Two examples are: http://www.theroyalgazette.com/apps/pbcs.dll/artikkel?Avis=RG&Dato=20011218&Kategori=BUSINESS&Lopenr=112180020&Ref=AR (See the "Linked Articles") and Amazon's "Customers who bought this book also bought:" feature I think it would work something like this TABLE 1 keyword_id | keywords TABLE 2 url_id | url | url_title TABLE 3 id | keyword_id | url_id this would be your basic search engine - for example you could look up a keyword in table 1 using that keyword_id get the url_id's that correspond and then get the url's and titles for display. I guess that the "similar srticles" feature would work the same way by taking the current url_id lookup the corresponding keyword_id's use those to query for url_id's that match those keywords and then grab the url and title for display. Confused? I am :) This seems like it would work, but seems too intensive... Maybe a different table structure which contains url_id | similar_url would be better? then you could look up the current url_id for url_id's of similar articles? Thanks for your help. olinux __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
