ChadR — Wed, 04 Apr 2007 19:28:55 +0000

It looks really good Megan! You are well on your way to being a PHP Developer!

Oh and I read your post on your blog about small fonts... Don't Look at my site *big grin*

ChadR — Wed, 04 Apr 2007 19:26:46 +0000

After re-reading your last post I noticed you will be administering them.

So I imaging you have an area in your freetext table that relates to the QuestionId field. You could just do the initial page I and after you do the table and after This Code

<?php
$optionsquery = mysql_query(\"SELECT * FROM survey_quickquizW07_options WHERE questionID=\".$QuestionArray[$i][0].\"\") or die (\"Database Error\");

while($row = mysql_fetch_array($optionsquery)) 

    {

$Per = $row['selected'] / $QuestionArray[$i][2] ;

echo \"<tr><td>\" . $row['optiontext'] . \"</td><td>\". $row['selected'] . \"</td><td>$Per</td></tr>\";

    }
?>

Add something like

<?php
$freetextquery = mysql_query(\"SELECT * FROM survey_quickquizW07_freetext WHERE questionID=\".$QuestionArray[$i][0].\" AND approved = 1\") or die (\"Database Error\");
            

while($row = mysql_fetch_array($freetextquery )) 
{
//Show the results
}
?>

Megan — Wed, 04 Apr 2007 19:25:14 +0000

No, they are being approved before they get posted. I have an admin area that I'm using for some other applications I bult. They have the same process - I log in, see a table of what has been submitted, check an approved field which updates an "approved" field in the database. Only the fields that have approved=1 will be diplayed, everything else is hidden.

I managed to write a separate query to show the freetext questions after the multiple choice. See the results here:

http://www.housing.uwaterloo.ca/surveys/quick-quiz_submit.php
(there's a lot of dummy text in there right now but it's mostly together)

ChadR — Wed, 04 Apr 2007 19:02:29 +0000

There are other ways you could do it so that it could order them by Question ID (If you do want them ordered by QuestionId you should specify that in a ORDER BY clause) I am still unclear as to what you plan to do with the questions that are not freetext. Unless these results are monitored I would highly discourage allowing them to be displayed. This is a pretty large security threat and some people would surely get inappropriate. If you have questions about how I did something or why please let me know I willing to share with the community.

Megan — Wed, 04 Apr 2007 18:56:11 +0000

Okay, that helps. Then I could do a separate query for the freetext questions. It won't order them the way I want them but I guess I might have to live with that.

I am going to try showing the answers to the freetext questions but only after I approve them. I have a separate admin area (that I'm also using for other things), where I go in and read the submissions and approve them. That process just updates an "approved" field in the freetext table. So the query for the freetext questions would only show the answers WHERE approved=1. I think i can work that out.

ChadR — Wed, 04 Apr 2007 18:40:46 +0000

the q. and o. are just shorten name. If you notice in the FROM part of the query there is a letter after the name of the table. It refers to the table alias much like when I do AS for the NumAnswered column. You could remove the alias after the table name but this just saves time.

So in Plain English

SELECT q.*, SUM(o.Selected) as NumAnswered FROM `survey_quickquizW07_questions` q LEFT JOIN survey_quickquizW07_options o on o.QuestionId = q.QuestionId GROUP by o.QuestionID

States...

Please show me all the columns in the table survery_quickquizW07_questions (q.*). Now match all the options with each Question (LEFT JOIN survey_quickquizW07_options o on o.QuestionId = q.QuestionId). Please add up all the items in the Selected Column that match each question and show it to me (SUM(o.Selected) as NumAnswered & GROUP by o.QuestionID).

I still don't understand What you going to do with the freetext questions. Are you going to show all the freetext questions answers?

If you only want to show the multiple choice questions you could do a WHERE statment in your Questions query

<?php
$questions = mysql_query(\"SELECT q.*, SUM(o.Selected) as NumAnswered FROM `survey_quickquizW07_questions` q LEFT JOIN survey_quickquizW07_options  o on o.QuestionId = q.QuestionId WHERE q.questionType = 'multchoice' GROUP by o.QuestionID\") or die (\"Database Error\");
?>

Megan — Wed, 04 Apr 2007 18:27:52 +0000

I have another table for the freetext answers. Each question, in the questions table, has a field for the questionType. My old code was splitting it so that the table of answers was generated only for the questions marked "multchoice". The "freetext" questions just pulled the contents of the freetext table. So I need to have the questionType field out of the questions database so I can show those questions too. The freeetext questions shouldn't have any matching answers in the options table.

What are all the q. and o. parts in the select query doing? That's what really confused me. There are "other" fields on some questions and 5 other questions that just have text entry boxes.

ChadR — Wed, 04 Apr 2007 18:20:00 +0000

Let me try to explain it to you.

the NumAnswered Calculates the total number of times that Question was responded to.

In this statement

<?php
$questions = mysql_query(\"SELECT q.*, SUM(o.Selected) as NumAnswered FROM `survey_quickquizW07_questions` q LEFT JOIN survey_quickquizW07_options  o on o.QuestionId = q.QuestionId GROUP by o.QuestionID\") or die (\"Database Error\");
?>

.
I used a LEFT JOIN to add the SUM of all the numbers in the Selected Field for Options that matched the QuestionId So now you have a way to get a percentage out.

What do you want to Appear in the "Other" section? I didn't understand that. Also what do you want to appear in the Fill in the Blank Questions?

Megan — Wed, 04 Apr 2007 18:02:19 +0000

Shoot, I really don't have time to understand that and I really don't like using code I don't understand. Oh well, might have to do it anyway

I don't have a row called NumAnswered - what is that for? Is that the same as "selected"??

Thanks for all your help though! I have that plugged in but now I need to re-figure out how to do all the free text entires. That's why there was that if ($row['questionType'] == "multchoice") conditional...

ChadR — Wed, 04 Apr 2007 16:40:14 +0000

Maybe you will want to limit the % to decimals points as well you can use the Sprintf command to do so.

Just add

<?php
$Per = sprintf(\"%.2f\", $Per);
?>

After the $per variable is defined.

Let me know if I can be of any further assistance.

- Chad