PHP While loop seperating unique categories from multiple 'Joined' tables
- by Hob
I'm pretty new to Joins so hope this all makes sense.
I'm joining 4 tables and want to create a while loop that spits out results nested under different categories.
My Tables
categories
id | category_name
pages
id | page_name | category
*page_content*
id | page_id | image_id
images
id | thumb_path
My current SQL join
<?php $all_photos =…