Welcome to WebmasterWorld Guest from 54.145.101.33

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Detect random answers

Rows of suscpiciously similar questionnaire answers

     
10:10 pm on Mar 29, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 28, 2005
posts:97
votes: 0


Hi

I have a PHP/MySQL quiz/questionnaire and want to detect random or missing responses.

Something like "SELECT IF {MORE THAN 3 ZEROS IN A ROW} OR {MORE THAN 5 'YES' IN A ROW}"

Any suggestions? Would doing this at the SQL query be most efficient?

Many thanks in advance,

Ed

2:12 am on Apr 1, 2006 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12547
votes: 2


Well, an SQL query means that you have to write the data to the table before you query it. Do you care that the user has supplied these random answers before or after the fact?
8:58 am on Apr 1, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 15, 2004
posts:1867
votes: 0


You have to write an SQL Query entertaining the requirements.
9:23 am on Apr 2, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 28, 2005
posts:97
votes: 0


Sorry yes, I want to detect them *after* they have been put in the table.
9:35 am on Apr 2, 2006 (gmt 0)

Full Member

10+ Year Member

joined:Sept 13, 2003
posts:214
votes: 0


Forget SQL and get down to some basic statistics. You can never be sure whether someone is or isn't filling in your form in good faith, even if they put down five 0s in a row (or some other such 'indicator'). If you get enough respondents all the outliers will fade into background noise.
2:41 pm on Apr 2, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 28, 2005
posts:97
votes: 0


In fact there are statistical analyses of random responding, which I am referring to for this purpose. I would still like to know how to detect strings of the same number - the interpretation is a seperate issue.