1 john Oct 22, 2007 02:13
3 john Oct 22, 2007 11:04
Ok, Thanks for that... though it does generate the following..
BTW, I placed the above code in index.main.php
Additional information about this error:
MySQL error!
Table 'wowfactor2.T_items__itemstag' doesn't exist(Errno=1146)
Your query:
SELECT count(*) as tag_total, tag_name
FROM T_items__itemstag join ( evo_items__tag ) on ( itag_tag_ID = tag_ID ) group by tag_ID
The database for tags is
evo_items__tag
??
4 yabba Oct 22, 2007 11:05
You're getting closer ;)
This FROM T_evo_items__tag needs to either be FROM T_items__itemtag or FROM evo_items__itemtag ( whichever works )
¥
5 john Oct 22, 2007 11:59
Bingo ...
FROM evo_items__itemtag worked.
Appreciated. How do I make the tags active links that will list the related posts ?.... or am I pushing my luck Blondie :)
6 yabba Oct 22, 2007 12:02
echo '<li><a href="'.$baseurl.'?tag='.$tag->tag_name.'" title=" view all posts tagged with '.$tag->tag_name.' ">'.$tag->tag_name.' ( '.$tag->tag_total.' )</a></li>'."\n";
;)
¥
7 john Oct 22, 2007 12:10
Your blood's worth bottling :)
Works great..
8 yabba Oct 22, 2007 12:10
Only cos it has such a high alcohol content ;)
¥
9 john Oct 23, 2007 03:27
ISSUE RESOLVED
ignore this post
I haven't used tags on any of my posts yet so I can't really test this, but you should be able to do something like :
If that works then the answer to your question is yes ;)
¥
*edit*
Correcting code ( tag_count is tag_total :p )
and another correction ( to the table name ;) )