...

View Full Version : 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