Is this possible to do? I thought I did it before..
I cant figure out why this will only list one category when i place the COUNT() item there.
If I change it to l.listing_id AS total it will list all 5 items though,
Am i doing something very wrong??
-- WHY IS THIS BELOW CAUSING ONLY 1 TO LIST???
-- CUZ THERE ARE 5 REALLY, THEYLL WORK IF I TAKE OFF COUNT
COUNT(l.listing_id) AS total
FROM categories AS c
LEFT JOIN listings AS l
l.assign_category = c.category_id
ORDER BY title ASC