I would like to form a query that given a gallery id, it would return the gallery title and a list of the image extensions in the gallery, separated by commas.
Is there a function that I can use on a query such as:
I'm trying to use a mysql pagination script to cycle through the galleries, when I show the list of galleries, i want to include a list of the all the distinct extensions used in the gallery. The way that the pagination script works is that I pass a table field to sort by, but if i want to sort by the extensions, then i would need a subquery to get the list.
Todd_Z wrote:I think you missed the point entirely.
Considering you've only talked about wanting MySQL to give you a comma separated string of a search in the thread so far, yeah I did miss that bit.
Todd_Z wrote:I'm trying to use a mysql pagination script to cycle through the galleries, when I show the list of galleries, i want to include a list of the all the distinct extensions used in the gallery. The way that the pagination script works is that I pass a table field to sort by, but if i want to sort by the extensions, then i would need a subquery to get the list.
Sounds like you need to refactor/reorganize the class to work with more liquid data.