182) $bar = 'purbar.gif'; else if ($width > 164) $bar = 'blupurbar.gif'; else if ($width > 146) $bar = 'blubar.gif'; else if ($width > 128) $bar = 'greblubar.gif'; else if ($width > 110) $bar = 'grebar.gif'; else if ($width > 92) $bar = 'yelgrebar.gif'; else if ($width > 74) $bar = 'yelbar.gif'; else if ($width > 56) $bar = 'oryelbar.gif'; else if ($width > 38) $bar = 'orbar.gif'; else if ($width > 20) $bar = 'redorbar.gif'; return '' : 'class="bar">'); } ?> Rate My Life Quiz - Final Results

Rate My Life Quiz Stats

The following results box shows the average scores for each rating, based on quiz scores.


'. getBar($life) .' '. $life .''; else echo ''; ?> '. getBar($mind) .' '. $mind .''; else echo ''; ?> '. getBar($body) .' '. $body .''; else echo ''; ?> '. getBar($spirit) .' '. $spirit .''; else echo ''; ?> '. getBar($friends) .' '. $friends .''; else echo ''; ?> '. getBar($love) .' '. $love .''; else echo ''; ?> '. getBar($finance) .' '. $finance .''; else echo ''; ?>
Life: Not enough information
Mind: Not enough information
Body: Not enough information
Spirit: Not enough information
Friends/Family: Not enough information
Love: Not enough information
Finance: Not enough information

Gender Averages

'; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.mind) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.mind != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $mind = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.body) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.body != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $body = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.spirit) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.spirit != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $spirit = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.friends) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.friends != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $friends = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.love) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.love != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $love = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.finance) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.finance != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $finance = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, COUNT(*) FROM life_results b, gender a WHERE a.gender_id=b.gender_id GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) echo ''; ?>
Life:  
'. $row[0] .''. getBar($life) .' '. $life .'
Mind:  
'. $row[0] .''. getBar($mind) .' '. $mind .'
Body:  
'. $row[0] .''. getBar($body) .' '. $body .'
Spirit:  
'. $row[0] .''. getBar($spirit) .' '. $spirit .'
Frnds/Fmly:  
'. $row[0] .''. getBar($friends) .' '. $friends .'
Love:  
'. $row[0] .''. getBar($love) .' '. $love .'
Finance:  
'. $row[0] .''. getBar($finance) .' '. $finance .'
Counts:  
'. $row[0] .''. number_format($row[2]) .'

Age Group Averages

'; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.mind) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.mind != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $mind = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.body) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.body != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $body = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.spirit) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.spirit != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $spirit = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.friends) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.friends != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $friends = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.love) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.love != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $love = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.finance) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.finance != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) { $finance = round($row[2], 1); echo ''; } echo ''; $result = mysql_query("SELECT a.name, a.disp_order, COUNT(*) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id GROUP BY a.name, a.disp_order ORDER BY a.disp_order"); while ($row = mysql_fetch_row($result)) echo ''; ?>
Life:  
'. $row[0] .''. getBar($life) .' '. $life .'
Mind:  
'. $row[0] .''. getBar($mind) .' '. $mind .'
Body:  
'. $row[0] .''. getBar($body) .' '. $body .'
Spirit:  
'. $row[0] .''. getBar($spirit) .' '. $spirit .'
Frnds/Fmly:  
'. $row[0] .''. getBar($friends) .' '. $friends .'
Love:  
'. $row[0] .''. getBar($love) .' '. $love .'
Finance:  
'. $row[0] .''. getBar($finance) .' '. $finance .'
Counts:  
'. $row[0] .''. number_format($row[2]) .'