\n"; $rs = db_query_read("ambmembers", $sql); echo "\n"; $i = 0; while($row = mysql_fetch_row($rs)) { list($Member_ID, $Photo_Thumbnail, $name, $City, $State, $Country, $show_location, $Show_Profile) = $row; if($i % 4 == 0) echo "\n"; $Photo_Thumbnail = cleanPhotoPath($Photo_Thumbnail); $Member_Name = trim($name); $Loc = ""; if(intval($show_location) == 1) { $City = properCase($City); if(strlen($State) == 2) $State = strtoupper($State); $Loc = $City . (strlen($City) > 0 && strlen($State) > 0 ? ", " : "") . $State; if(strlen($Country) > 0 && $Country != "USA") $Loc .= (strlen($Loc) > 0 ? ", " : "") . $Country; } echo ""; $i++; if($i % 4 == 0) echo "\n"; } if($i % 4 != 0) echo "\n"; echo "
"; if($Show_Profile) echo ""; echo "\"""; if($Show_Profile) echo ""; echo "
\n"; echo "$Member_Name
$Loc"; echo "
 
\n"; ?>