Meet Some Of Our Patients
Support is a critical element throughout this process. Reading about the progress of others can bring comfort during trying times. Read what some of our patients have to say about their experiences.
0) $Time_String = "AND m.Post_Date_Doc < " . intval($_REQUEST['Next_Stamp']) . " "; else $Time_String = ""; $database = "ambmembers"; $query = "SELECT m.Member_ID, su.display_name, m.City, m.State, m.Post_Date_Doc, " . "m.Surgeon_Comments, p.Comments, m.Photo_1_URL, m.Photo_2_URL, m.Photo_Gallery, " . "su.user_id " . "FROM members m " . "LEFT OUTER JOIN profilecomments p ON m.Member_ID = p.Member_ID " . "INNER JOIN " . SYS_DATABASE . ".sys_user su ON m.Member_ID=su.legacy_id " . "WHERE LENGTH(m.Surgeon_ID) > 0 AND m.$Surg_ID_String $Time_String " . "AND m.OH_Visible=1 AND IFNULL(m.Owner_Approved,'') IN ('Yes','') " . "AND m.account_status='active' AND su.account_status='active' " . "ORDER BY Post_Date_Doc DESC LIMIT 10"; #echo "query=$query\n"; $result = db_query_read($database, $query); if(!$result) echo "
SQL: $query
Error: $mysql_error
\n"; else $Post_Date_Doc = ""; #Lets take out those nasty html tags from the patients comments $Comments = strip_all_tags($Comments,''); if (strlen($Comments) > 1000) { $Comments = substr($Comments, 0, 1000); $pos = strrpos($Comments, " "); $Comments = substr($Comments, 0, $pos); $Comments .= "... Click here to read more"; } $Surgeon_Comments = strip_all_tags(stripslashes($Surgeon_Comments)); echo "
\n";
echo "$MemberName
\n"; if($AllowContact && $profileUserID) echo "Send a Personal Message
\n"; echo $Post_Date_Doc; if ($Photo_Gallery == "Yes") echo "![\"\"](\"")
\n";
echo "
\n"; if($AllowContact && $profileUserID) echo "Send a Personal Message
\n"; echo $Post_Date_Doc; if ($Photo_Gallery == "Yes") echo "
\n";
if (strlen($Comments) > 0)
echo "Personal Comments:
$Comments
\n"; if (strlen($Surgeon_Comments) > 0) echo "Comments About $Surg_Name:
$Surgeon_Comments
\n"; echo "
$Comments
\n"; if (strlen($Surgeon_Comments) > 0) echo "Comments About $Surg_Name:
$Surgeon_Comments
\n"; echo "
\n"; flush(); } # Now, we want to provide a link to see the next five testimonials # However, we don't want to put a link if we have already gone through all of them. # One way for sure to tell that we don't have any more is if the number appearing on the current page is less than 5. # Our query statement above has a limit of 5. # If it pulls up less than five, this means that there weren't enough left to put 5 on the page. # $num is the number of records pulled up. # We only want the link if $num is 5. if ($num == 10) echo "
\n"; ?>