Thread Starter
Jim R
(@jim-r)
To clarify, I’m trying to add Tagged images to Post Archive pages, not Posts.
Of course there are stored in the WordPress taxonomy database: In wp_term the “tag” is linked with a “term_id” and in wp_term_relationships the object_id <-> term_id are linked, therefore the object_id is in my case the picture id.
In tags.php look for the function “find_images_for_tags”, it will pull out images based on a tag
Thread Starter
Jim R
(@jim-r)
Cool. I forgot to check the relationship table. I’ll take a look at it and hopefully make sense of it.
Thread Starter
Jim R
(@jim-r)
Ok…not making much of it. I gave it a shot on my own before I checked it out. I know little about Joins, and I know little about mysql_fetch_assoc.
To start I have called the tag_id I’m working with this:
$wp_tagID = get_query_var(‘tag_id’);
$qImage = ‘SELECT * FROM wp_ngg_pictures AS np
LEFT JOIN wp_term_relationships AS tr ON np.pid = tr.object_id
LEFT JOIN wp_term_taxonomy_id AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
LEFT JOIN wp_terms AS t ON tt.term_id = t.term_id
WHERE tt.taxonomy = ngg_tag
AND t.term_id = “$wp_tagID”
‘;
$pImage = mysql_query($qImage);
while($images = mysql_fetch_assoc($pImage)) {
echo $images;
}
I’m getting this error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jwrbloom/public_html/resources/wp-playerProfile.php on line 109
In my mind I’m trying to get all the information from the wp_ngg_pictures table.
From there I’m trying to match the pid with the object_id in the wp_terms_relationships table. (128,140,147)
I’m taking the term_taxonomy_id associated with those images (1200) and trying to match it with the term_id (517) in the wp_term_taxonomy table where the taxonomy = ngg_tags.
Then somehow, I’m trying to match the term_id to the tag_id I brought to the page in the very beginning.
did you try to use just the function find_images_for_tags() for your purpose, maybe it’s easier this way ?
Thread Starter
Jim R
(@jim-r)
How would I go about doing that? It would need to have a variable, like find_images_for_tags($nameFirst . ‘ ‘ . $nameLast)
if you know the tag_id , then you can search for the images or did I missed something ?
Thread Starter
Jim R
(@jim-r)
Where are you intending for me to use this?
I’m hard coding this in the template PHP file that via an Include. Are you saying it would look like:
find_images_for_tags($wp_tagID, mode = “ASC”), and the number included would be regulated by the Dashboard?
