pull custom fields values from wp-database in a nested foreach loop

Question

I am trying to display custom fields on my template values of which i am pulling from postmeta table doing something wrong with a loop or not writing the foreach args correctly not sure whats the problem pastebin link for the code http://pastebin.com/eyPD6Qws

basically i want to display 15 div's with 3 cols so to say (name, photo,region)

To make it more simple to explain exactly what i am doing is using a plugin called flutter(yes i know it is dead now) but it works for me i am creating profiles for say agents there individual pages work perfectly but now i want to create a page where i display small brief of everyone's profile (like we have portfolio pages) for which i have created a code(which can be seen here http://pastebin.com/eyPD6Qws)

Answer 1

Technically, you should use WP's built-in class WP_Query to pull the information and I am sure that will alone simplify your entire process.

Answer 2

Use a simple loop. Inside the loop and call the meta data with the basic template function get_post_custom().

// Short'n'dirty...
if ( have_posts() ) : while ( have_posts() ) : the_post();

    $meta = get_post_custom( get_the_ID() );

    echo "\n<hr />{$GLOBALS['post']->post_title} Custom Data:\n<pre>".var_export( $meta, true ).'</pre>';

endwhile; endif;

Answer 3

Answer to my problem, finally sorted it (happy-face) {

            global $wpdb;  
        $broker_names = $wpdb->get_results("SELECT meta_value
            FROM $wpdb->postmeta 
            WHERE meta_key = 'B_name'  ORDER BY  meta_id DESC  ", ARRAY_A);  
        $b_region = $wpdb->get_results("SELECT meta_value
            FROM $wpdb->postmeta 
            WHERE meta_key = 'Region' ORDER BY  meta_id DESC ", ARRAY_A);

            $b_photo = $wpdb->get_results("SELECT meta_value
            FROM $wpdb->postmeta 
            WHERE meta_key = 'Photo' ORDER BY  meta_id DESC ", ARRAY_A); 


                for($d=0; $d<=count($b_names); $d++)
                {
                    echo '<div id="b-group"><dl class="b-badge">';
                    echo '<dt class="b-image">';
                    echo '<img src='.get_site_url().'/wp-content/files_flutter/'.$broker_photo[$d]['meta_value'].' /></dt> ';
                    echo '<dd class="b-name"><span>'. $b_names[$d]['meta_value'].'</span>'; 
                    echo '</dd><dd class="b-region">';
                    $r_region = $b_region[$d]['meta_value'];
                    $new_region = unserialize($r_region);
                    echo '  '.$new_region[0].'</dd> ';  
                    echo '</dl></div>';

                }

}