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:
(See the "Linked Articles")
and Amazon's "Customers who bought this book also
I think it would work something like this
keyword_id | keywords
url_id | url | url_title
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.
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
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]