<?php
global $wpdb;
$broker_names = $wpdb->get_results("SELECT meta_value
FROM $wpdb->postmeta
WHERE meta_key = 'Broker_name' ORDER BY meta_id DESC ", ARRAY_A);
$broker_region = $wpdb->get_results("SELECT meta_value
FROM $wpdb->postmeta
WHERE meta_key = 'Region' ORDER BY meta_id DESC ", ARRAY_A);
$broker_photo = $wpdb->get_results("SELECT meta_value
FROM $wpdb->postmeta
WHERE meta_key = 'Photo' ORDER BY meta_id DESC ", ARRAY_A);
for($i=0; $i<=13; $i++)
{
echo '<div id="broker-group"><dl class="broker-badge">';
echo '<dt class="broker-image">';
foreach($broker_photo as $postimage )
{
for($d=0; $d<=1; $d++)
{
echo '<img src='.get_site_url().'/wp-content/files_flutter/'.$postimage['meta_value'].' /></dt> ';
}break;
}
foreach($broker_names as $postnames)
{
for($e=0; $e<=1; $e++)
{
echo '<dd class="broker-name"><span>'. $postnames['meta_value'].'</span>';
}break;
}
foreach ($broker_region as $postregion)
{
for($r=0; $r<=1; $r++)
{
echo '</dd><dd class="broker-region">';
$roost_region = $postregion['meta_value'];
$new_region = unserialize($roost_region);
echo ' '.$new_region[0].'</dd> ';
}break;
}
echo '</dl></div>';
}
?>