Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pc77
  • Order by date
  1. pc77

    Help! Select query nested probably

    Hi r937, thanks for helping me out. I'l show you an example of what im trying to accomplish: http://shopping.yahoo.com/ There you can among others see: Clothing & Accessories Women's, Men's, Shoes, more... Every main categoy and subcategory are linked to another page, thats what im...
  2. pc77

    Help! Select query nested probably

    Thanks r937 for your reply. Your code works fine, but i don't get the data i need. I know you can solve this. My first question was not clear enough.. Here comes a clarification: I need to get data output like this: CatTitel, CatID (for the main category where parentID = 0) CatTitle, CatID...
  3. pc77

    Help! Select query nested probably

    I am stuck! Please help me out.. I am using this query right now, to produce a list of main categories. All main categories have the value 0 in ParentID. SELECT CatID, CatTitle, ParentID FROM cats WHERE ParentID = '0' ORDER BY CatTitle ASC This query produce a return like: 5,Cars, 0...
    • pc77
    • Thread
    • Replies: 5
    • Forum: MySQL

Part and Inventory Search

Back
Top