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; }