Newbie Question - How to combine these queries?

Dev Shed Forums Sponsor:

January 5th, 2013, 09:19 PM

agentk

Registered User

Join Date: Jan 2013

Posts: 1

Time spent in forums: 5 m 40 sec
Reputation Power: 0

Newbie Question - How to combine these queries?

I am trying to extract raw data from my WordPress database and have been successful is doing so, but I needed to use a different query every time. Could someone help me out on how to combine these queries into one query?

PHP Code:


		
			
<?php include('db.php'); $id=mysql_real_escape_string($_GET['id']); $sql=mysql_query("SELECT * FROM wp_posts WHERE ID = '$id'"); $count=mysql_num_rows($sql); $row=mysql_fetch_array($sql); $title=$row['post_title']; echo $title; mysql_close($sql); $sql=mysql_query("SELECT * FROM wp_postmeta WHERE post_id='$id' AND meta_key = 'post_type_value' "); $count=mysql_num_rows($sql); $row=mysql_fetch_array($sql); echo $row['meta_value']; mysql_close($sql); $sql=mysql_query("SELECT * FROM wp_postmeta WHERE post_id='$id' AND meta_key = 'mabp_description' "); $count=mysql_num_rows($sql); $row=mysql_fetch_array($sql); echo $row['meta_value']; mysql_close($sql); $sql=mysql_query("SELECT * FROM wp_postmeta WHERE post_id='$id' AND meta_key = 'mabp_thumbnail_url' "); $count=mysql_num_rows($sql); $row=mysql_fetch_array($sql); echo $row['meta_value']; mysql_close($sql); $sql=mysql_query("SELECT * FROM wp_postmeta WHERE post_id='$id' AND meta_key = 'mabp_swf_url' "); $count=mysql_num_rows($sql); $row=mysql_fetch_array($sql); echo $row['meta_value']; mysql_close($sql); $sql=mysql_query("SELECT * FROM wp_postmeta WHERE post_id='$id' AND meta_key = 'mabp_height' "); $count=mysql_num_rows($sql); $row=mysql_fetch_array($sql); echo $row['meta_value']; mysql_close($sql); $sql=mysql_query("SELECT * FROM wp_postmeta WHERE post_id='$id' AND meta_key = 'mabp_width' "); $count=mysql_num_rows($sql); $row=mysql_fetch_array($sql); echo $row['meta_value']; mysql_close($sql); ?>

Thanks! Much help is appreciated.

January 6th, 2013, 12:39 AM

E-Oreo

Lost in code

Join Date: Dec 2004

Posts: 7,931

Folding Points: 945 Folding Title: Novice Folder

Time spent in forums: 2 Months 7 h 48 m 54 sec
Reputation Power: 7053

You would use a left or inner join on it; the former for optional meta keys and the latter for required meta keys. For example:

Code:

SELECT
  wp_posts.post_title,
  post_type_meta.meta_value AS post_type_value,
  mabp_description_meta.meta_value AS mabp_description_value
FROM wp_posts
LEFT JOIN wp_postmeta AS post_type_meta ON
  post_type_meta.post_id = wp_posts.ID
  AND post_type_meta.meta_key = 'post_type_value'
LEFT JOIN wp_postmeta AS mabp_description_meta ON
  mabp_description_meta.post_id = wp_posts.ID
  AND mabp_description_meta.meta_key = 'mabp_description'
WHERE wp_posts.ID = '$id'

However, note that:
* The mysql_* PHP library is deprecated and mysqli or PDO should be used instead.
* You don't need to call mysql_num_rows unless you're actually going to use the value.
* mysql_close closes the connection to the MySQL server, which is not what you want to be doing after every query; you shouldn't be calling this in your script.

__________________
PHP FAQ
How to program a basic, secure login system using PHP

Quote:

Originally Posted by Spad

Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around

Newbie Question - How to combine these queries?

Developer Shed Advertisers and Affiliates