Feeding a Drill Down Menu with categories, subcategories and subSubcategories from a database

Posted by Hassan on Stack Overflow See other posts from Stack Overflow or by Hassan
Published on 2010-05-09T21:23:49Z Indexed on 2010/05/09 21:28 UTC
Read the original article Hit count: 405

Filed under:

left-join

Hi everyone, I have a Drill Down menu and I want to have it gets its elements from a database, I am using php and MySQL and the table (categories) looks like this :

http://yfrog.com/jctablehsj

I can't figure out how I can extract these information in a way I could put it inside the Drill Down Menu !

I found the recursive method (with LEFT JOINs) and the nested method which I barely understood and again I couldn't apply it to the Drill Down Menu.

I found that some people found out a solution with left join and group by but couldn't understand or copy their example !

I would be more than gratefull if you could give me the extact of the query.

Thanks a lot for your hard work,

Hassan

Related posts about left-join

Select query 2-3 times faster than view

as seen on Stack Overflow - Search for 'Stack Overflow'
This query run alone: SELECT -- lots of columns FROM (((((((((((`table1` `t1` LEFT JOIN `table2` `t2` ON(( `t2`.`userid` = `t1`.`userid` ))) LEFT JOIN `table3` `t3` ON(( `t1`.`orderid` = `t3`.`orderid` ))) … >>> More
Mysql - Help me change this single complex query to use temporary tables

as seen on Stack Overflow - Search for 'Stack Overflow'
About the system: - There are tutors who create classes and packs - A tags based search approach is being followed.Tag relations are created when new tutors register and when tutors create packs (this makes tutors and packs searcheable). For details please check the section How tags work in this system… >>> More
Left Join in Subsonic3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin var q = from c in categories join p in products on c equals p.Category into ps from p in ps.DefaultIfEmpty() select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName… >>> More
SQL is this equvelent to a LEFT JoIn?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is this equvelent to a LEFT JOIN? select distinct a.name, b.name from tableA a, (select name from tableB) as b It seems as though there is no link between the two tables. Is there an easier / more efficient way to write this? >>> More
Another rookie question; How to implement Count() here?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this query: SELECT mt.*, fordon.*, boende.*, elektronik.*, business.*, hem_inredning.*, hobby.* FROM classified mt LEFT JOIN fordon ON fordon.classified_id = mt.classified_id LEFT JOIN boende ON boende.classified_id = mt.classified_id LEFT JOIN elektronik ON elektronik.classified_id = mt… >>> More

Developer IT