SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Query Problem

  1. #1
    Non-Member
    Join Date
    Sep 2004
    Location
    London
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query Problem

    Hey Guys

    I'm building a site in php that lists available products, each product is categorised by genre, category and sub category. The DB structure consists of a genre table, category table, sub category table, product table and a lookup table where each product can be referenced by genre, category and subcategory.

    I'm trying to build a keyword search facility where by you can search for products by genre, category, sub category or by product name. But I seem to be a bit stuck trying to build this query any help would be much appreciated.

    Crabby

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    could you show a few sample rows of each table

    then please explain the fields that you will ahve on the search form and how they should work
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •