...

how do I put links around my group concat categories

conware
04-18-2012, 08:47 PM
Hi guys, I created three tables with the following fields:

Categories:

C_ID
C_NAME


Blog:

B_ID
B_NAME
B_BODY
B_DATE


Categories / Blog table:

categorie_ID
blog_id


I am trying to display my blog posts with some data next to them in which categorie the post is located. So I used a join and GROUP CONCAT to display them like this:

Categories: Books, Music

However I have one problem I want to make links to each categorie.
But if the are grouped together I won't able to seperate the links.
so the need to link to there categorie ID.
So I can make the links something like this:

index.php?mode=blog&cat=musicID

then It should get a list with all my posts that have a categorie of music.
However I only need to know how can I link the links to there names?
Do i need to use something els then GROUP CONCAT ore do i need to do that with php code?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum