Mysql help required
Im trying to select a list of categories, and display them, as well as list number of videos in each category.
I have 2 tables, categories (cat_id, cat_name), and videos (vid_id, vid_catid, etc). cat_id = vid_catid.
I need 1 query that will select the category names + number of rows in the video table that has [...]