That is not how you would query for a featured image. This:
$thumb = $wpdb->get_var("SELECT ID FROM $wpdb->posts where post_parent="$value" and post_type="attachment"");
Should be:
$thumb = $wpdb->get_var("SELECT meta_value FROM $wpdb->postmeta where meta_key = '_thumbnail_id' and post_id = '$value'");
That is assuming that $value
is a post ID.
“Featured” images are attachments, but not all attachments are featured images. That is why this works sometimes but not others.
However, you’ve just reinvented the wheel. What you are doing is exactly what get_post_thumbnail_id
does, though that function uses proper Core mechanisms.
Related Posts:
- Get post featured image id with $wpdb
- Add class name to post thumbnail
- Delete original image – keep thumbnail?
- the_post_thumbnail responsive srcset not populating with custom image size
- Set custom name for generated thumbnails
- How to add multiple image sizes of the same size with add_image_size
- change set_post_thumbnail_size according to post type admin page
- Can’t extract and set SVG dimensions
- Getting Thumbnail Path rather than Image Tag
- How to crop thumbnail height to auto with set width
- Image uploader with “Set Featured Image” link on front end
- adding an id to the_post_thumbnail
- How can I display my featured image correctly inside my single posts?
- Featured image upload finished hook
- Generate thumbnail for images with the same size as thumbnails
- Implementing Zurb’s Interchange Into WordPress
- How to get_posts having post thumbnail?
- Display the first image from a post in RSS feed
- Filter For Featured Image
- add_image_size and add_filter(‘image_size_names_choose’, ‘my_custom_image_sizes’) not working with wordpress 3.5.2
- Custom post type thumbnail / Media Library WP_DEBUG notice [closed]
- Add body class based on existance of post thumbnail. Code works but receiving PHP Notice
- Delete all thumbnails for a post
- How to display thumbnail + tags + title of a child page?
- Archive Thumbnail Gallery
- How to delete posts that does not have a thumbnail?
- WordPress Uploader Editor shows broken image
- How do i show wordpress attachments from current post?
- How to get full absolute url for post attachment?
- Can’t get image size set with set_post_thumbnail_size() function
- How to check the array of featured images IDs
- Show LightBox when clicking on featured image [closed]
- Is it possible to nest get_previous_post()?
- Get ID of featured image using “get_post_thumbnail_id(the_ID())” – without printing to screen?
- what is the difference between timthumb and post thumbnail?
- Duplicated featured image is not showing
- Create thumbnail size only for a few images?
- How to find post with broken image link and delete that post
- Else condition not working while using has_post_thumbnail
- Only Display Thumbnail if Larger Than
- WP Query to set post thumbnail for existing old posts
- get_post_thumbnail_id() Doesn’t return value [closed]
- Why is the post title and content automatically being displayed in the post thumbnail (Featured image)?
- How to deal with wordpress images?
- Disable post thumbnails in Twenty Thirteen child theme
- How can I find the first post in a category that has a featured image and then return the get_the_post_thumbnail()?
- Post thumbnail throwing size limit parameters in
- How do I add a default thumbnail to elseif when no get_field(‘photos’), and no post thumbnail exists?
- Problem with showing featured image
- Displaying Post Featured Images on All Pages
- Getting img src from thumbnail_id using javascript
- Easy way to update a single translation entry without having to translate
- If the_post_thumbnail(); is this – echo this text
- Featured image not working
- Insert post’s category name into thumbnail string
- Thumbnails in ACF Query Results
- Icon over thumbnail according to post format
- Tweak next_post_link for it to include thumbnail
- The location of the html output from the_post_thumbnail();
- the_post_thumbnail() doesn’t always return selected size
- Get last post in category thumbnail
- WordPress not creating “large” thumbnails
- how can I call a posts featured image in any template?
- get_the_post_thumbnail($post->ID, ‘thumbnail’); not working. How can I solve this?
- Is it possible to add the_post_thumbnail to style.css?
- Getting featured image of particular size.
- Different thumbnails for index and article page
- Smaller thumbnail in the_content
- Attachment Image using wrong src?
- Unable to set Custom “Link URL” for Featured Image, and More?
- On what point (hook) does the_/has_post_thumbnail() load?
- First Image not loading on Mobile Version of Website
- Thumbnails not being generated for PDF files
- Make 1st Slide of PowerPoint file to be the Post thumbnail preview image
- Is it possible to set Featured Image using HTML?
- Set featured image from auto generated video thumbnail url php
- Use Post Title as alt text for Featured Image
- How to cropped thumbnail image without distorting it?
- WordPress default srcset with hard crop
- wp_get_attachment_metadata()[‘image_meta’] fetch WP metadata or EXIF?
- White Blank screen and issue to get thumbnail in
- Set Featured Image Based on Custom Field
- Post thumbnail on specific template
- Using lower resolution/size images for thumbnails on posts index
- How to have featured image show in standard RSS Widget
- Link from Thumbnail to Post not working
- Featured Image metabox (postimagediv) doesn’t appears when it should
- Thumbnails not showing in blog
- Featured Image inserted through custom query, does not show up
- How to import linked images and make them featured -> automagically
- Change role’s settings influence post-thumbnail
- Wrap Featured Image in a Link
- Thumbnail images
- Featured Image Thumbnail Sizing
- Featured Image Isn’t showing with cropped, How to show it?
- How to modify Media Library images DPI [ image quality down to make small in size ] [closed]
- How to add text & call to action button to featured image on homepage?
- Featured image as background in a div using headway
- php code for image fetching
- Why not attaching images after impoting using wp cli