Is this possible to do...

[m_tCh]

Here is what I have right now. I have a project db. Employee's can currently fill out a form which adds their project to the database. (20 Different fields total if that matters).

I now need to add a customer satisfaction survey for each project. This survey will be filled out by "customers" who are internal employees from different divisions.
The survey will have the same 3 questions:
1. How would you rate your exp. (1-5 scale)
2. Are you likely to use what you learned....(1-5 scale)
3. Text input for comments/suggestions

This survey will be located in a different folder from the database interface but on the same server. Since we add new projects all the time, I figured I would start by making drop down box that connects to the database and populates its options with the names of the projects. The "Customer" would come to this page as the default and be instructed select the project they are going to fill out a survey for from the dropdown box. It would pass the ID onto the next page so that the survey would be matched with the correct project. Here is where I run into problems. I am still very novice with php. (I could figure this out if only one person would be taking the survey but there would be multiple people.)How would I keep track of multiple results?
Say that Question 1 is feeding into a field called "Q1". Is there a way to add the 1-5 value that is already in Q1 in the DB for that particular project and divide by the total times the survey has been completed and then update Q1 with that result. Ditto for Question 2. If that isn't possible or hard to program. Is there a way to make a sub-datebase in MySQL where there would be a Survey database within each of the fields in each project. For the comments/suggestions, could I have it just add the comment into the text field to what is already there without updating(overwriting the last comment)? Or would there be a better way to handle this?

Any help on this is greatly appreciated!
Thanks!
Mitch

[fire_cracker]

Okay, I am a ltitle confused about what you are trying to do, but I will do my best to give you a hand.

First off, create a table in your database. If you need some help with the syntax check out the mysql website, or if you are running a database front end such as PHPmyAdmin it will walk you through creatinga table.

Devise the fields you will need such as an id, the id of the project the servey is about, the answers to your questions, maybe something about who took the survey (like email address, first name, favorite brand of beer, or whatever).

Now, each time someone take sthe survey, and new record will be created in the database. You can then pull the information out for all the projects, some of the projects, or one of the projects. Now to get the average answer you can do the math at the time that the number needs to be displayed. Like this:

//set some variables equal to 0 for lter calculations
$count = 0;
$q1 = 0;
$q2 = 0;
$q3 = 0;

//connect to the database
mysql_connect('server','username','password');
mysql_select_db(db_name);

//run a query as a varable to get the information out of the db
$result = mysql_query("SELECT * FROM tblSurvey WHERE project_id='n'");

//Now get all of your answers
while($row = mysql_fetch_array($result)) {
  //add one to the total count
  $count++;

  //Tally up the answers the word in the ['']'s is the field name in the database
  $q1 = $q1 + $row['q1'];
  $q2 = $q2 + $row['q2'];  

  $q3 = $q3 + $row['q3'];

}

//Now do the math to display the average answer of all the questions

$q1_avg = $q1/$count;
$q2_avg = $q2/$count;
$q3_avg = $q3/$count;
?>

Now all you have to do is display the variables. Just to let you know this code is completly untested, and just a general idea of what I think you are trying to do. If you need some further help, or I totaly mistook what you were trying to do let me know 🙂