homepage Welcome to WebmasterWorld Guest from 50.19.172.0
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

5+ Year Member



 
Msg#: 12314 posted 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

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



 
Msg#: 12314 posted 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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 12314 posted 8:58 am on Apr 1, 2006 (gmt 0)

You have to write an SQL Query entertaining the requirements.

s9901470

5+ Year Member



 
Msg#: 12314 posted 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

10+ Year Member



 
Msg#: 12314 posted 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

5+ Year Member



 
Msg#: 12314 posted 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