OK, I have came this far.
I made a function called proba() that lists all the page IDs classified by meta values and those clasified by meta keys. I just don’t know how to make this IDs into LINKS to the real pages that correspond to the IDs!
here is the code
<?php
//my stuff
function proba() {
global $wpdb;
$proba_metakeys = $wpdb->get_results(“SELECT meta_key FROM $wpdb->posts, $wpdb->postmeta GROUP BY ‘meta_key'”);
foreach ($proba_metakeys as $proba_metakey)
{
echo $proba_metakey->meta_key;
echo “<br>”;
$proba_metavalues = $wpdb->get_results(“SELECT meta_value FROM $wpdb->posts, $wpdb->postmeta WHERE meta_key = ‘$proba_metakey->meta_key’ GROUP BY ‘meta_value'”);
foreach ($proba_metavalues as $proba_metavalue)
{
echo “<p> $proba_metavalue->meta_value </p>”;
$proba_metaids = $wpdb->get_results(“SELECT post_id FROM $wpdb->posts, $wpdb->postmeta WHERE meta_key = ‘$proba_metakey->meta_key’ AND meta_value = ‘$proba_metavalue->meta_value’ GROUP BY ‘post_id'”);
foreach ($proba_metaids as $proba_metaid)
{
echo “<h4> $proba_metaid->post_id </h4>”;
}
}
}
}
?>
If someone can help me on this; it would be great!!
Nearly there: this is it; the function incorporates the wp_list_pages() function to list the sorted page IDs. Now All I need is to show only one meta_tag list at the time, preferably selected from a drop down menu (wich menas that the first query is unnecessery – object &proba_metakey would get replaced by a selected object from the drop down button)
<?php
function proba()
{
global $wpdb;
$proba_metakeys = $wpdb->get_results("SELECT meta_key FROM $wpdb->posts, $wpdb->postmeta GROUP BY 'meta_key'");
foreach ($proba_metakeys as $proba_metakey)
{
echo $proba_metakey->meta_key;
echo "<br>";
$proba_metavalues = $wpdb->get_results("SELECT meta_value FROM $wpdb->posts, $wpdb->postmeta WHERE meta_key = '$proba_metakey->meta_key' GROUP BY 'meta_value'");
foreach ($proba_metavalues as $proba_metavalue)
{
echo " $proba_metavalue->meta_value";
$proba_metaids = $wpdb->get_results("SELECT post_id FROM $wpdb->posts, $wpdb->postmeta WHERE meta_key = '$proba_metakey->meta_key' AND meta_value = '$proba_metavalue->meta_value' GROUP BY 'post_id'");
foreach ($proba_metaids as $proba_metaid)
{
echo "<h4> $proba_metaid->post_id </h4>";
echo wp_list_pages("include=".$proba_metaid->post_id);
}
}
}
}
?>
