Pull featured image using SQL in Wordchimp plugin

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Web & Mobile Design Posted 3 years ago


Hours to be determined
Less than 1 week

Start Date

June 23, 2013


The Wordchimp Wordpress plugin has a PHP file where all actions are executed.

The code pulls in data from the wp_posts table using SQL. I also need Featured Image data to be pulled in but this data is not stored in that table.

Here is the relevant PHP code in Wordchimp: http://pastebin.com/E0Qgep4e

I think this is the code to add a featured image or maybe there is another way:

$Featured_image = $wpdb->get_results("
     SELECT p.*
       FROM net_5_postmeta AS pm
      INNER JOIN net_5_posts AS p ON pm.meta_value=p.ID
      WHERE pm.post_id = $da_id
        AND pm.meta_key = '_thumbnail_id'
      ORDER BY p.post_date DESC
      LIMIT 15

The task is simply to add in the featured image data with the post excerpt data. That's it.

I can give more specific details by chat. If you have gchat, that is preferred.

About the Client

(5.00) 65 reviews

United States
Bedford 06:36 PM

121 Jobs Posted
63% Hire Rate, 1 Open Job

$8,941 Total Spent
80 Hires, 3 Active

$5.84/hr Avg Hourly Rate Paid
1,289 Hours

Member Since Oct 6, 2009