I have the following SQL statement:
SELECT section_category, section_order, section_content, section_active, section_practice, section_category_name, subcat FROM people_section_categories, people_sections WHERE section_category = section_category_id AND subcat IN ( 0, 1, 2, 3 ) AND (section_practice =3 OR section_practice =0 ) AND section_active =1 AND section_person =414 ORDER BY subcat DESC , section_order, name_order
Below are the results:
You will notice in the results that there are two sets of duplicate section categories (section_category 76 and section_category 20). I need a way to get rid of the duplicates that have a section_practice value of zero. Can this be done in the SQL statment or do I need to do this in the PHP? Thanks!