PHP - Linking MySQL tables and counting results
Solved/Closed
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
-
Updated on Apr 17, 2017 at 06:13 AM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Apr 24, 2017 at 03:14 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Apr 24, 2017 at 03:14 PM
Related:
- PHP - Linking MySQL tables and counting results
- Https www facebook com profile php id 100005621131172 - Facebook Forum
- Facebook ID disabled - Facebook Forum
- View-source https www facebook com profile php id 100010157447383 - Facebook Forum
- How to check who viewed my Facebook profile (2022)? - Guide
- Php redirect - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Updated on Apr 24, 2017 at 03:15 PM
Updated on Apr 24, 2017 at 03:15 PM
Found the solution. It needed an inner join aparently.
2 beers for me:)
I really appreciate thank you messages as a payment for solving issues :o)
SELECT support_type.Support_Type, COUNT(*) AS qty
FROM support_type, raw_data
WHERE support_type.Support_ID=raw_data.Support_Type AND raw_data.Date BETWEEN '$start' AND '$end'
GROUP BY support_type.Support_Type
ORDER BY qty DESC
2 beers for me:)
I really appreciate thank you messages as a payment for solving issues :o)