2 yabba Oct 22, 2007 10:19

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
??
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 )
¥
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 :)
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";
;)
¥
Your blood's worth bottling :)
Works great..
Only cos it has such a high alcohol content ;)
¥
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 ;) )