Re: Select with while loops

Rick, Welcome to the list - we try not to byte, er, bite... I am trying to do a select that will display events by category, but will NOT display a category name if it is empty (has no events). 2 tables: categories and events events contains a field called category_id that corresponds to the id

Select with while loops

I am trying to do a select that will display events by category, but will NOT display a category name if it is empty (has no events). 2 tables: categories and events events contains a field called category_id that corresponds to the id of a category in categories. I am doing a 'while' loop for