SiteId; $Name = $result->Name; $Location = $result->LocationAddress; $City = $result->City; $State = $result->State; $Zip = $result->Zip; $Description = $result->HomeCopy; } $interviews = array(); $query = mysql_query("SELECT * FROM Interviews WHERE SiteId='$Id'"); while($result = mysql_fetch_object($query)) { $interviews[sizeof($interviews)] = $result->InterviewId; } $interviewee_names = ''; $interviewee_count = 0; $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='2'"); while($result = mysql_fetch_object($query)) { $Why .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; $interviewee_names .= ''.$result->IntervieweeName . ', '; $interviewee_count += 1; } $interviewee_names = substr($interviewee_names, 0, strlen($interviewee_names)-2); $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='3'"); while($result = mysql_fetch_object($query)) { $GoodBad .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='4'"); while($result = mysql_fetch_object($query)) { $Successful .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='5'"); while($result = mysql_fetch_object($query)) { $Advice .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='36'"); while($result = mysql_fetch_object($query)) { $MaleFemale .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; $interviewee_names .= ''.$result->IntervieweeName . ', '; $interviewee_count += 1; } $interviewee_names = substr($interviewee_names, 0, strlen($interviewee_names)-2); $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='37'"); while($result = mysql_fetch_object($query)) { $Age .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='38'"); while($result = mysql_fetch_object($query)) { $Addiction .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='39'"); while($result = mysql_fetch_object($query)) { $ChooseRehab .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='40'"); while($result = mysql_fetch_object($query)) { $ChooseFacility .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='41'"); while($result = mysql_fetch_object($query)) { $HowLong .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='42'"); while($result = mysql_fetch_object($query)) { $Approach .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='43'"); while($result = mysql_fetch_object($query)) { $Well .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='44'"); while($result = mysql_fetch_object($query)) { $Better .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='45'"); while($result = mysql_fetch_object($query)) { $Success .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='46'"); while($result = mysql_fetch_object($query)) { $Relapse .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='47'"); while($result = mysql_fetch_object($query)) { $Recommend .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='48'"); while($result = mysql_fetch_object($query)) { $GenAdvice .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Answers INNER JOIN Interviews ON Answers.InterviewId=Interviews.InterviewId WHERE Answers.InterviewId IN (".implode(",",$interviews).") and QuestionId='49'"); while($result = mysql_fetch_object($query)) { $Other .= "" . $result->IntervieweeName . ": " . $result->Answer . "
"; } $query = mysql_query("SELECT * FROM Interviews WHERE InterviewId='$InterviewId'"); while($result = mysql_fetch_object($query)) { $City = $result->City; $State = $result->State; } $query = mysql_query("SELECT * FROM Facilities WHERE fid='$fid'"); while($result = mysql_fetch_object($query)) { $fname = $result->fname; $faddress = $result->faddress; $fcity = $result->fcity; $fstate = $result->fstate; $zip = $result->fzip; $phone = $result->fphone; $website = $result->fwebsite; $description = $result->fdescription; $slug = $result->fslug; } ?> <? echo $Name; ?> - <? echo $City; ?>, <? echo $State; ?> Rehab Review

Rehabio

Recent Reviews

, | See other rehab reviews


,



"; ?> Interview'; echo($interviewee_count > 1 ? 's' : ''); echo ' from '; echo $interviewee_names; echo ''; } ?>
Why did you choose this facility?
'; echo $Why; echo '
'; } else { } if (isset($GoodBad)) { echo 'Tell us about the experience - was it positive or negative?
'; echo $GoodBad; echo '
'; } else { } if (isset($Successful)) { echo 'Do you feel the program was successful?
'; echo $Successful; echo '
'; } else { } if (isset($Advice)) { echo 'What advice would you give somebody considering going to this facility?
'; echo $Advice; echo '
'; } else { } if (isset($MaleFemale)) { echo 'Are you male or female?
'; echo $MaleFemale; echo '
'; } else { } if (isset($Age)) { echo 'How old were you when you attended this facility?
'; echo $Age; echo '
'; } else { } if (isset($Addiction)) { echo 'Describe your addiction:
'; echo $Addiction; echo '
'; } else { } if (isset($ChooseRehab)) { echo 'Why did you choose to go to rehab?
'; echo $ChooseRehab; echo '
'; } else { } if (isset($ChooseFacility)) { echo 'Why did you choose this facility?
'; echo $ChooseFacility; echo '
'; } else { } if (isset($HowLong)) { echo 'How long were you in this rehab facility? Inpatient or outpatient?
'; echo $HowLong; echo '
'; } else { } if (isset($Approach)) { echo 'What is this facility\'s approach to the treatment process?
'; echo $Approach; echo '
'; } else { } if (isset($Well)) { echo 'What do you think this rehab facility does well?
'; echo $Well; echo '
'; } else { } if (isset($Better)) { echo 'What could this facility do better?
'; echo $Better; echo '
'; } else { } if (isset($Success)) { echo 'Overall do you feel your treatment here was successful or not?
'; echo $Success; echo '
'; } else { } if (isset($Relapse)) { echo 'Did you relapse after treatment?
'; echo $Relapse; echo '
'; } else { } if (isset($Recommend)) { echo 'Would you recommend this facility to a friend or a family member?
'; echo $Recommend; echo '
'; } else { } if (isset($GenAdvice)) { echo 'What general advice would you give to somebody dealing with addiction?
'; echo $GenAdvice; echo '
'; } else { } if (isset($Other)) { echo 'Have you been to any other rehab facilities?
'; echo $Other; echo '
'; } else { } ?>