PHP compare values from Mysql

Question

The MySql table looks like:

    id    |        values   
  --------------------------------
    41    |    154, 256, 526, 50
    86    |    542, 586, 785, 41

I want to compare values from this database with values from results from another MySql query. From that another query I get result for specific user and valus, for example:

user id: 41
values: 154,526,50

How can I compare this two database "values" columns and get as a result number of total different values and the values that are different?

In this example the result of that PHP function will be:

total number of different values: 1
different value: 256

What have you tried?

juergen d
– juergen d

2012-07-09 12:59:00 +00:00
Commented Jul 9, 2012 at 12:59 — juergen d
– juergen d, Commented Jul 9, 2012 at 12:59
Did you try exploding both fields and comparing arrays?

Peon
– Peon

2012-07-09 12:59:55 +00:00
Commented Jul 9, 2012 at 12:59 — Peon
– Peon, Commented Jul 9, 2012 at 12:59

Sherlock · Accepted Answer · 2012-07-09 14:40:02Z

3

By normalising your database. Save those values in a different table and create a new couplings table, connecting the values to the user. This will ease your development dramatically.

EDIT: The query would then look like this:

SELECT
    value
FROM
    couplings_table
WHERE
    user_id = X
AND
    value NOT IN (SELECT
                    value
                  FROM
                    couplings_table
                  WHERE
                    user_id = Y)

edited Jul 9, 2012 at 14:40

answered Jul 9, 2012 at 12:59

Sherlock

7,6356 gold badges42 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marcus Adams Over a year ago

Please show what the query would look like in a normalized database design.

roymustang86 · Accepted Answer · 2012-07-09 13:01:41Z

2

You can use array_diff:

http://php.net/manual/en/function.array-diff.php

answered Jul 9, 2012 at 13:01

roymustang86

8,72323 gold badges72 silver badges103 bronze badges

Comments

Sahin Yanlık · Accepted Answer · 2012-07-09 13:09:38Z

1

explode with "," and use array diff or search every item in_array and use results. I think array_diff is just for this.

answered Jul 9, 2012 at 13:09

Sahin Yanlık

1,2012 gold badges12 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP compare values from Mysql

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related