TinyButStrong - the PHP Template Engine
Categories > TinyButStrong general >

Display as Tags

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs

By: krish
Date: 2017-02-25
Time: 09:19

Display as Tags

Hi
I am trying to display list of articles in a page and associated Tags. These tags are stored in separate many-many table between article id, tag id in mysql table. (article, tag, article-tag tables). How can i display the following dynamically?. Please suggest. Thanks

e.g

My First Article
tbs,template,travel

My Second Article
tbs,lifestyle,fashion

---
    
By: Skrol29
Date: 2017-02-27
Time: 22:54

Re: Display as Tags

Some Db Engines have an aggregate function that concatenates strings. Like GROUP_CONCAT() in MySQL.
With such a function the solution is in your query.

Otherwise you can use TBS sub-blocks.