How to select and use multiple key/value rows in tables like 'wp

It’s hard to switch out of “normal” MySQL mode and start working with data stored in key/value format. The ‘wp_options’ table is an example of storing data in this key/value format. I was working on a cron job that required data from the ‘wp_options’ table. This is how I got where I needed to go:

$sql = "SELECT option_name, option_value FROM wp_options WHERE option_name IN ('key1','key2','key3')";
$result = mysql_query($sql);

$data = array();

while(list($key, $value) = mysql_fetch_row($result)) {
	$data["$key"] = $value;
}

$key1value = $data['key1'];
$key2value = $data['key2'];
$key3value = $data['key3'];

$sql = "SELECT option_name, option_value FROM wp_options WHERE option_name IN ('key1','key2','key3')";

$result = mysql_query($sql);

$data = array();

while(list($key, $value) = mysql_fetch_row($result)) {

$data["$key"] = $value;

}

$key1value = $data['key1'];

$key2value = $data['key2'];

$key3value = $data['key3'];

So if you want to retrieve specific key/value data in one pass with MySQL and then assign the results to PHP variables, this method might work for you:

2 thoughts on “How to select and use multiple key/value rows in tables like ‘wp_options’ (PHP/MySQL)”

andy@awendt.com says:

August 7, 2013 at 12:31 am

You NEED to switch over to PDO or mysqli!

1. Brandon Hoover says:
  
  August 7, 2013 at 1:28 am
  
  Agreed. Switch out these depreciated mysql extensions for whatever you are using.
  The query used for selecting data from a key/value table is solid though.

Share this:

2 thoughts on “How to select and use multiple key/value rows in tables like ‘wp_options’ (PHP/MySQL)”

Leave a Reply Cancel reply