homepage Welcome to WebmasterWorld Guest from 54.204.90.135
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Detect random answers
Rows of suscpiciously similar questionnaire answers
s9901470




msg:1305066
 10:10 pm on Mar 29, 2006 (gmt 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

 

coopster




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

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?

Habtom




msg:1305068
 8:58 am on Apr 1, 2006 (gmt 0)

You have to write an SQL Query entertaining the requirements.

s9901470




msg:1305069
 9:23 am on Apr 2, 2006 (gmt 0)

Sorry yes, I want to detect them *after* they have been put in the table.

mm1220




msg:1305070
 9:35 am on Apr 2, 2006 (gmt 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.

s9901470




msg:1305071
 2:41 pm on Apr 2, 2006 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved