Ok i have found the solution , here it is:

You make a file named "number.txt" in which you store the number. In PHP you retrieve the number and then +1's it if it isn't 4, else you set the number to 1. Then you save the new number into number.txt.

The code:

number.txt:

The form:

Greets, Graphix

Woaah, slow down Tiger.

Just ONE way to do this would be:

surveys table
id (autoincrement/tinyint/primary key)
survey_name (varchar)
max_respondants (int - stop collecting after certain amount)
active (tinyint - can switch off the survey manually)
form_html (text - place the 'cleaned' form html in here - just the inside 'guts' of the form - no form tags)

replies table
id (autoincrement/tinyint/primary key)
survey_id (foreign key on id in surveys table)
replies (text) - I'd use php functions serialize() and unserialize() to store the form $_POST variables as an array


Now this is a very basic setup, and somewhat complicates collating the data from the replies field due to the 'array' nature, but it's usable. I'm not using the active and max_respondants fields here, just for clarity.

At the top of your page, enter the code for finding the survey with the lowest number of respondants, something like:


All your forms will be sent to the formhandler.php page, where all you do is send the data to the db (after 'cleaning' it).
For 'replies' table:
The $_POST['survey_id'] field will give the survey_id field
Next delete the $_POST['survey_id'] so it doesn't interfere with your $_POST array:
The serialize($_POST) function should work to put the replies into a single field.

//EDIT//
Sorry G - went for a metaphysical walk during my reply.

Dear Graphix and Ardav,

Thanks so much! This is great! I was able to immediately understand your solution, Graphix, and I've gotten it to work! This really solves a big problem for me.

I haven't fully understood your solution yet Ardav, but I can see that this would give me much more control over the surveys and really simplify things. I need some time to study it though.

Thanks so much to both of you!
/JennyK

No worries Jen, G's reply is easy to implement if you just want a quick fix w.r.t. showing different forms and I suggest that you use that.

If this thread is still alive, could you mention how you're collating the data? Do you get one form and manually add data to a spreadsheet for example, or are your data items stored in a db? When feeling up to a challenge, you could get create some code to automatically collate your data for you and even create graphs for certain response types.

Dear Ardav,

Well, I have a fairly primitive collection method for the data: have an array storing answers from questions posed at the index file (same for all participants), and then another array with the answers to questions posed at the survey file (with several different versions).

function setup_file(){
global $id;
ignore_user_abort(true);
if(!file_exists("participants/$id.cht3_test1.results")){
$handle = fopen("participants/$id.cht3_test1.results","a");
// foreach($_POST as $key => $value){
// fputs($handle,"% ".$key.": ".$value."\n");
// }
}
ignore_user_abort(false);
}

function process_results(){
global $id;
global $_POST;
ignore_user_abort(true);
$handle = fopen("participants/$id.cht3_test1.results","a");
fputs($handle,"* ".gmdate("F j, Y, H:i:s")."\n");
foreach($_POST as $key => $value){
if($key{0}=="Q"){
fputs($handle,$key.": ".$value."\n");
}
}
fclose($handle);
ignore_user_abort(false);
}

I have to do a number of transformations of each of these files, and of course, and put them all in one file, to get the file format I need for the analysis (in SPSS).

I actually didn't write the original php, so I didn't actually write the above, I just know when to use it...so I haven't attempted anything more sophisticated because it is so hard to predict how long it will take (me) to be successful.

But I suppose I just have to create a file, open it for writing each time a survey is called, and then somehow append the values of the array separated by comma's on the same line (how do you avoid getting a new line character after each value), and then close the file....hmmm Now when I write it out it might not be that hard...

Any suggestions? This is maybe not the best way to do this, but it does seem comprehensible to me.

Thanks for your further interest and any help/comments.

/JennyK

Change the "\n" to a ",". However, you may need to input a "\n" at the start of the entry before the loop.

That's the offending bit that forced a new line after each value. Ideally you'd want to create a csv file for something like SPSS (I assume) - I never had much to do with SPSS, I tended to use Minitab, so I may be wrong here.

I don't know if SPSS could extract data from a db anyway - perhaps you'd have to create an xml file. In which case, you'd possibly be better off just sticking to your current setup (@ officionados - don't shoot me!).

You may find that php/MySQL could replicate the statistical calculations of SPSS. There's a PECL library and plenty of stats scripts online. I've seen some for ANOVAs, multiple range tests (e.g. Tukey), t-tests, calc of s.d., s.e.m, variance etc.