SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict Eric1776's Avatar
    Join Date
    May 2002
    Location
    Atlanta, GA
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database Schema Help

    I'm fairly new at setting up MYSQL databases. Here's what I need to do.

    I need a simple FAQ page with related links.
    I have an FAQ table setup and a related links table setup. The related links table contains links to all the sites and products that would be associated with a particular FAQ.

    So what I need is when a FAQ is shown, the links related to that particular FAQ will be listed also.

    I'm thinking maybe a third table is necessary? A table linking the FAQs with the Related Links.

    What would be the best way to setup my fields?

    I would particulary like it setup so that the Related Links come up according to the actual text contained in the FAQ question and answer.

    So if I have a link with a keywords contain "apple". If the word "apple" appears in the Question or Answer that link would be listed.

    Hope I'm not making this more confusing than it is.

  2. #2
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Five tables maybe?
    FAQ, Links, Keywords and tables for relationships FAQ-Links and Links-Keywords


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
  •