How to show tags only for publication images and albums?

ka6ym

Please help me...
How make the correct MySQL request for show tags result for all published albums and images?
I know that the comparison should go on three tables ... but nothing happens

ka6ym

Sorry, I made ​​a mistake in the topic title, the theme is called
"How to show tags only for published images and albums?"

sbillard

There is no convenient way.

You would have to make a query which gave you the ID fields of all the published albums and a separate one of all the published images.

Then you would have to query the `obj_to_tag` table and retrieve the unique IDs corresponding the type/objectid pair gathered above.

Then you can query the tags table for the names that go with those IDs

ka6ym

I'm a beginner in php please show me a example code.

acrylian

Well, if you are a beginner this is a good occasion to start learning the basics which this forum is not the place for.