SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Apr 2004
    Location
    Elyira, OH
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Two tables, linked with One table.

    nvm. delete this
    Last edited by mph; Jun 2, 2008 at 13:20.

  2. #2
    An average geek earl-grey's Avatar
    Join Date
    Mar 2005
    Location
    Ukraine
    Posts
    1,403
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code MySQL:
    SELECT p.product_id,
           p.product_title
      FROM categories AS c
    INNER
      JOIN categories2products AS c2p
        ON c2p.cat_id = c.category_id
    INNER
      JOIN products AS p
        ON p.product_id = c2p.prod_id
     WHERE category_titlesafe='$category'


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
  •