Mine

function display_directory($id, $table){
	global $db_database, $db;
	
	mysql_select_db($db_database);
	$get_query = "SELECT * FROM `".$table."` WHERE `".$table."` = '".$id."' LIMIT 1";
	$get_result = mysql_query($get_query, $db);
	$get_row = mysql_fetch_array($get_result);
	
	if($get_row){
	
	$search = "`members`.`".$table.'_id` = '.$get_row['id'];
	
	$query = "SELECT members.*, country.id, country.country AS country, state.id, state.state AS state, city.id, city.city AS city FROM (members JOIN country ON members.country_id = country.id JOIN state ON members.state_id = state.id JOIN city ON members.city_id = city.id) LEFT JOIN region ON members.region_id = region.id WHERE ".$search." ORDER BY country.country ASC, state.state ASC, city.city ASC, members.l_name ASC";
	
	$result = mysql_query($query, $db) or die(mysql_error());
	$row = mysql_fetch_array($result);
	
	$printed_states = array();
	$printed_cities = array();
	
	do{
		if($row['approved'] and $row['web'] and $row['expiration_date'] > date("Y-m-d") ){
			
			if($row['web']){
				if( !in_array($row['state'], $printed_states) ){
					$string .= '<div class="banner_1"><h1>'.$row['state'].'</h1></div>';
					
					$printed_states[] = $row['state'];
					
				}
				
				if( !in_array($row['city'], $printed_cities) ){
					$string .= '<div class="banner_2"><h2>'.$row['city'].'</h2></div>';
					
					$printed_cities[] = $row['city'];
					
				}
				
				$string .= '
	 <table class="member_directory">
		<tr>
		  <td>
		  	<table class="directory_main">
				<tr><td colspan="2"><h2><a href="#ahroiar">'.$row['f_name'].' '.$row['l_name'].'</a> <img src="../images/global/option.gif" alt="[ ]" /></h2><h3>'.$row['business'].'</h3></td></tr>
				<tr><td class="column_a"><p>Skills:</p></td><td class="column_b"><p>'.$row['skills'].'</p></td></tr>
				<tr><td class="column_a"><p>Location:</p></td><td class="column_b"><p>'.$row['city'].', '.$row['state'].'</p></td></tr>
			</table>
		  </td>
		  <td>
		    <table class="directory_contact">
			<tr class="header"><td colspan="2"><p>Contact Details</p></td></tr>
			<tr><td class="column_a"><p>Phone:</p></td><td class="column_b"><p>'.$row['w_phone'].'</p></td></tr>
';
			if($row['email']) $string .= '
			<tr><td class="column_a"><p>Email:</p></td><td class="column_b"><p><a href="#oiwaer">'.$row['email'].'</a></p></td></tr>
';
			if($row['website']) $string .= '			
			<tr><td class="column_a"><p>Website:</p></td><td class="column_b"><p>'.$row['website'].'</p></td></tr>
';
				$string .= '
			<tr><td class="column_a"><p>Address:</p></td><td class="column_b"><p>'.$row['street_1'].'</p><p>'.$row['city'].', '.$row['state'].' '.$row['postal'].'</p></td></tr>			
			</table>
			<div class="clear"></div>		  
		  </td>
		</tr>
	 </table>
';		
			
			} else {
			
			
			}
			
		
		
		}

	} while($row = mysql_fetch_array($result));
	
	return $string;
	
	} else return "Your search returned no results.";
}