So far I have
SELECT DISTINCT(showName) AS showName FROM ".$this->TABLES['tvepisodes']." ORDER BY showName ASC
which displays each show in a new table row.
I would like to be able to show the seasons beside each show aswell though.
I would like it to show
Show 1 -Season1- Season2
Show 2 -Season1- Season2-Season3
Can I do this in the same SQL select or would I have to do another select where distinct(season) ??
Thanks for reading.