function getAnswer($question_id, $session_id, $level)
{
$answerSQL = "SELECT * FROM facebook WHERE session_id = '{$session_id}' AND nav_tab_id = '{$question_id}'";
$asnwerSET = mysql_query($answerSQL) or die(mysql_error());
$answerROW = mysql_fetch_assoc($asnwerSET);
$result = $answerROW['answer'];
if (empty($result)) {
$result = 99;
}
if ($level == 2) {
$topParent = getTopParentID($question_id);
$answerSQL = "SELECT * FROM facebook WHERE session_id = '{$session_id}' AND nav_tab_id = '{$topParent}'";
$asnwerSET = mysql_query($answerSQL) or die(mysql_error());
$answerROW = mysql_fetch_assoc($asnwerSET);
$result2 = $answerROW['answer'];
if ($result2 != 1) {
$result = 88;
}
}
return $result;
}
function getTopParentID($id)
{
$mySQL = "SELECT * FROM navigation_tab WHERE nav_tab_id = '{$id}'";
$recSET = mysql_query($mySQL);
$recROW = mysql_fetch_assoc($recSET);
$nav_tab_id = $recROW['nav_tab_id'];
$parent_id = $recROW['parent_id'];
if ($parent_id == 0) {
return $nav_tab_id;
}
if ($parent_id != 0) {
$output = getTopParentID($parent_id);
}
return $output;
}
