php - In some way to calculate the number of entries in tags? -


tags:

id, name --------- 1   tag1 2   tag2 3   tag3  4   tag4  

tags_id:

id_tags, id_post -------------- 1          1     2          3     3          1    4          2    

how count how many posts tags?

i need mysql query..

i have problem , i'm beginner

select id_tags, count(id_post) id_post_count  tags_id  group id_tags 

Comments

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -