I'm trying to place *one* link for a specific tag/category in my sidebar - similar to the link that shows up beneath posts. I can't seem to pull it off, though. I was going to use get_tag_link, but the only parameter is using the Tag ID.
Where *is* the tag ID? I don't see it listed in the admin area, and when I go to look in the database under wp_tags and/or wp_tag_synonyms, I'm not allowed to "Browse". Is there somewhere else I need to look, or a better way to find the tag ID?
...and of course, in moments, I find the answer. Sorry to waste the server space.
For future reference (in case anyone else needs to know):
match the wp_term_taxonomy term_id for the taxonomy of "post_tag" to the term_id in wp_terms. That did it.
Posted 4 years ago #
I couldn't find a specific reference to it in the Codex either doodlebee. Thanks for letting us know.
Posted 4 years ago #
EDIT: you found the answer while I was typing this.
Well, I thought I'd share. Don't know how helpful this is, but with this query, I can have a custom link setup - a sort of "tag archive". My setup is such that the site is using WordPress as a CMS, and we're using the tagging system as a sort of "newsletter" assistance. So at the end of each post, they "tag" the post with what month and year they want the article to appear in. So as the site gets used, multiple tags will be added, and I wanted an archive list that I didn't have to update every month. So this is what I did - hope it helps someone else :)
<ul id="newsletter">
<?php $get_tags = ("SELECT $wpdb->term_taxonomy.*, $wpdb->terms.*
FROM $wpdb->term_taxonomy, $wpdb->terms
WHERE $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id
AND $wpdb->term_taxonomy.taxonomy = 'post_tag'
ORDER BY $wpdb->terms.term_id
ASC");
$tagquery = $wpdb->get_results($get_tags);
if ( $tagquery ) {
foreach ( $tagquery as $gt ) {
$tagid = $gt->term_id;
$tagslug = $gt->slug;
$tagname = $gt->name
?>
<li><a href="<?php echo get_tag_link($tagid);?>"><?php echo $tagname; ?></a> </li>
<?php
}
}
?>
</ul>That little piece of code will look for tags in the database and return them - name, ID and slug, and create a "links list" for them.
Like I said, hope it helps someone else!
This topic has been closed to new replies.
