SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2000
    Location
    Malaysia
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    We are developing a web directory and are having a problem to find a way to do targeted banner rotation for the different category result pages.
    What we're trying to do is, just show computer related banner when someone click on the computers and Internet Category; showing business related banners when someone click on business and economy category.

    What can I find a proper script for doing this? If anyone have any good suggestion, it is much appretiated.

    ------------------

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If you keep your ads in a table within your database simply add a keywords field. You can enter in the appropriate keywords. Then in your SQL statement or stored procedure that you use to build the query you can send the keyword that they searched on and do a like comparison.

    i.e.:

    select * from Banners where keywords like '%computer%'

    ------------------
    Wayne Luke - Sitepoint Moderator/Internet Media Developer
    Digital Magician Studios - Making Magic with Web Applications
    wluke@digitalmagician.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •