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
- Undefined index: php - Guide
- Https //m.youtube.com/home.php _rdr facebook page php php php - Facebook Forum
- Database connection error (1): the mysql adapter 'mysql' is not available. ✓ - Windows Forum
- Php redirect to another page - Guide
- Disadvantages of linking instagram to facebook - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
150
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)