Recent Profile Updates

$sql

\n"; $rs = db_query_read(SYS_DATABASE, $sql); $shaded = false; while($row = mysql_fetch_row($rs)) { list($Profile_Update_Date, $Member_ID, $City, $State, $Country, $show_location, $name, $Surg_Class, $Postclin_Type, $Postclin_OpenLap) = $row; $Profile_Update_Date = date("m/d/y", $Profile_Update_Date); $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; } if ($Postclin_Type == "RNY - type unknown") $Postclin_Type = "RNY"; elseif($Postclin_Type == "VSG") $Postclin_Type = "Vertical Sleeve Gastrectomy"; elseif ($Postclin_Type == "Other") $Postclin_Type = ""; $Surgtype = trim($Postclin_OpenLap . " " . $Postclin_Type); if(strlen($Surgtype) > 0) $Surg_Class .= "
($Surgtype)"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $shaded = !$shaded; } ?>

Updated	Name, Location	Status
$Profile_Update_Date	$Member_Name" . (strlen($Loc) > 0 ? " $Loc" : "") . "	$Surg_Class