Search the Community

I was wondering if anyone could help me. A customer completes an assessment, each answer is a radio value between 1-5 and there are 10 questions. So therefore; Assessment Table assessmentid | studentid | q1 | q2 | q3.....q10 1 - 1001 - 1 - 5 - 3 - 2 The careers table has 10 careers which are each rated between 1-5 (this is set for each career) Careers Table careerid | careername | q1 | q2 | q3.....q10 1 - Doctor - 5 - 2 - 1 - 3 Im trying to create a results page which will check one sequence against another such as q1 in the assessment table against q1 in the careers table. To explain further, the user will input a value between 1-5 for question 1. This will be matched for the q1 value for career1. This will be repeated for each question up until question 10. The overall result (% match) will be displayed - i.e. the %match for the user and that particular career. This process will then be repeated for all remaining careers. I want the results to be shown in descending order and only display the top 5. The results should be shown as Career Name (result % match) Hyperlink (to external website) At the minute I have it working but it has quite a lot of queries such as: <?php $career1sequence1 = mysql_result (mysql_query ("SELECT `q1` FROM `careers` WHERE `careerid ` = '1'"), 0): $question1 = mysql_result (mysql_query ("SELECT `q1` FROM `assessment` WHERE `studentid` = $session_studentid"), 0); ?> <?php $career1result1 = $question1/$career1sequence1; if ($career1result1>1) { $career1result1 = $careersequence1/$question1 ?> This query is repeated for every question input/career sequence value. Would anyone know if there is an easier way to do this that is more straightforward? Any help is appreciated.