I get data from a table
wp_posts and now I need to get data from the table
wp_postmeta that match the ID captured in
wp_posts table .
The data that I need to grab in the table
product_img3 as shown in image below.
This is a view of my
I need to show
ID, post_title, product_img1, product_img2, product_img3. Here's the SQL:
$show_info = $pdo("SELECT p.*, pm.* FROM wp_posts p JOIN wp_postmeta pm ON p.post_id = pm.meta_id WHERE p.post_type = 'wpcproduct'" );
Question: Can you help me to show this data for ID 103?