Grant

South Africa

Feb
1
comment Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
I appreciate the detail you have supplied in this answer.... very insightful
Feb
1
comment Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
Thanks for the very thorough explanation, I didn't know how to get the sub queries wrapped together in one "Main query" I guessed it should have that structure but ...... SQL is not very intuitive :)
Feb
1
accepted Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
Feb
1
comment Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
Yes, there is a possibility of 0, thanks that also works great.
Feb
1
comment Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
Ah, I see what you are saying... your first query works perfectly.
Feb
1
revised Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
added 47 characters in body
Feb
1
revised Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
deleted 1 character in body
Feb
1
asked Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
Jan
24
awarded Popular Question
Jan
17
awarded Yearling
Jan
17
awarded Yearling
Nov
16
awarded Caucus
Nov
6
awarded Nice Answer
Oct
29
comment php-sql limit query per category
This works like a charm
Sep
29
awarded Supporter
Sep
25
revised All sub-menus are showing up on click
added 571 characters in body
Sep
25
comment All sub-menus are showing up on click
Thanks, your answer did solve the problem of selecting the parent element correctly but my approach of appendTo() was not the way to go. I ended up using CSS to correctly place the sub-menu position:absolute where I needed it.
Sep
25
accepted All sub-menus are showing up on click
Sep
24
comment All sub-menus are showing up on click
@ Hieu Le your fiddle works fine but I am appending the sub-menu to site-content it toggles open individually now but does not toggle closed again because it has been removed from the parent li so there is nothing there. Your answer is thus incomplete.
Sep
23
comment All sub-menus are showing up on click
@nevermind I tend to agree, I have them clicking open individually now but not toggling closed again.
1 2 3 4 5