Query That Gardening Database
Now we are making progress.
I have the database loaded up and ready to go. Now it is time to get fancy and pull something out of it.
Started by doing nothing fancy, just built a query that pulled out any item that had the word "Tree" in the title.
Now I have built the query up a little more and am displaying title, price and description. Not just that, but added the ability to query for items within a certain price range.
Is the thinking cap turned on here?
Given that I have promised a unique database driven affiliate website - couldn't we use this type of information to create pages that are unique from anything else out there?
How About This Idea.
Let's say we have a page for a cherry tree. On that same page we could have links to other related pages - pages that are in the "Tree" category.
Also, what about Trees that are priced within plus or minus 10% of the cherry tree price? That wouldn't be difficult to do at all.
With the information given in the datafeed we can come up with some creative ways to display the information.
March 18th, 2008 09:24
Are you building the database query to where it could link to products on other affiliate database websites?
For example, if someone reaches the "cherry tree" page in the gardening site, could the database also have links to a "cherry wood flooring" product on another database affiliate site about "flooring"?
How can you create the database to find and link to related keyword pages in all the future websites we build?
March 18th, 2008 18:36
Brian,
Wasn't planning on doing what you are suggesting - would rather not rely on another site being available.
My plan for this first datafeed site is to set it up in such away that going to the next ShareASale site is seamless - should just have to upload another datafeed and THE SCRIPT handles it.
Dave
April 2nd, 2008 07:53
Good that you had your vacation and are back here on this datafeed site code.
I agree that this makes sense to keep the script designed that you can just go through a seamless duplication for each ShareASale vendor.
It would be reasonable to create our own linking to other related products onother sites once we have built enough of these first.