Count total values that differ

[EchoFool]

Hey

 

Im trying to check a table of fields to see how many of those fields have different values.

 

I tried it by using FieldName!=FieldName but it always returns the same answer of zero even if there is different values in different rows.

 

This is my query:

SELECT Count(UserID) AS Total FROM users WHERE Age!=Age AND `In`='1' AND TableID='".$row['TableID']."'

 

Table:

User | Age | TableID

2    |  20 |    2

1    |  22 |    2

 

From the above table there are 2 rows that do not match for AGE - but my query always returns 0.

 

Any ideas?

 

Hope you can help!

[Buddski]

By saying Age != Age you will always get 0 because the Ages will never match each other.

 

What you need to do is use GROUP BY like so.

SELECT Count(UserID) AS Total FROM users WHERE `In`='1' AND TableID='".$row['TableID']."' GROUP BY `Age`

 

Hope this helps.

[EchoFool]

Good thinking! Im surprised i didn't think of that!