I wanted to know if there are any good tutorials or books that show you how to set up the following (for example):
I have a site that consists of a few text based dynamic pages and hundreds of dynamic pages that are based on products that are sold on the site. Say I am using PHP and MySQL for this site.
Someone decides to search for "pink shirt" on Google/Yahoo, and my site comes up as selling "Pink Shirt". when the clicks the link to go to my site, they are presented with a list of related content that deal with "Pink Shirt". So let's say I have 10 dynamic pages that exist on my site that sell different types of "Pink Shirt", and so the visitor is given a hyper linked title w/ a basic description of the page for these 10 dynamic pages.
How does this work, or is this possible? I see it being done quite a bit and am not sure how it is done.