britus
-
Posts
7 -
Joined
-
Last visited
Posts posted by britus
-
-
understood. Thank you.
-
Thanks for that. I'll give it a go this evening.
What did you mean by "I would also recommend using using valid column names"? I was trying to keep everything descriptive so I have a better understanding of what I am learning.
Thanks
-
I have two table -
categories - cat-id, cat-title
posts - post-id, post-cat-id, post-titleI want to search through all rows in 'posts' and get the number of posts based on each category in 'categories', echo 'cat-title' - number of posts
if no posts then echo 'cat-title' - "no posts".
posts are assigned a post-cat-id relative to cat-id.
I tried using joins WHERE cat-id = post-cat-id AND cat-title = 'a-category' but that only shows results when posts are assigned 'a-category'.
If that category does not exist in 'posts' then nothing shows
How, in your opinion, should I approach this?
Thanks
select from table with output from another table
in MySQL Help
Posted
Excellent. It worked great Barand. Thank you