php - What kind of algorithm should I use to find similarities in a db? -

-

let's have 1000 users app. ask them 100 questions answers yes/no , record answers in seperate table.

now, want see people has given same answers @ least 20 questions.

what kind of algorithm should follow in order this? relevant keywords googling?

p.s. work in wamp environment.

join answers table itself, selecting answers share same question_id , answer have different user_id. group rows both user_ids , use having clause exclude less 20 matching answers.

example looking users similar user user_id "1":

select distinct a2.user_id answers inner join answers a2         on a.question_id = a2.question_id        , a.answer = a2.answer        , a.user_id != a2.user_id a.user_id = 1 group a.user_id, a2.user_id having count(*) >= 20;

technically don't need group a.user_id in case i've left there in case want modify where clause return results more 1 a.user_id.


Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

java - Sql2o with postgres, No results were returned by the query -

-
the other questions i've found title deal non-select queries. i'm using java 8, sql2o 1.5.4, , postgresql 9.5.3. my userservice looks like: public class userservice { private final pgservice pgservice; public userservice(pgservice _pgs) { this.pgservice = _pgs; } public user getuserbyid(int id) { string sql = "select id, firstname, lastname, email, team_id teamid users id = :id;--"; user user; try (connection c = pgservice.getconnection()) { user = c.createquery(sql) .addparameter("id", id) .executeandfetchfirst(user.class); } return user; } } my user looks like: public class user { private int id; private string firstname; private string lastname; private string email; private string passhash; private int teamid; /*getters , setters*/ } my test looks like: public class userservicetest { pr...
Read more