gretty — Sun, 02 Apr 2006 03:29:46 +0000

can you do them all at once ?

Triexa.com — Tue, 21 Feb 2006 16:31:03 +0000

I joined the table for each additional field i wanted to check...

timjpriebe — Tue, 21 Feb 2006 13:38:11 +0000

If I understand correctly, you were wanting to check two records at once. They needed to have one record with one value, as well as another record with the second value.

I've tried that before and been unsuccessful. What was the solution you used?

Triexa.com — Sun, 19 Feb 2006 03:51:33 +0000

Quote: I want to select all rows where the user has field_id[1] a value of 'aaa' and also has a field_value[2] of 'bbb'...

Umm no, I don't want either to be true.

Anyways, I ended up getting it through a series of INNER JOINS, and it seems to work just dandy!

Thanks to everyone, anyways

altweb — Sun, 19 Feb 2006 03:49:37 +0000

If I am reading your first post correctly...I think changing the AND to an OR will get the results you are looking for from your example. The OR will return a record if either is true.

Quote: WHERE (f.field_id=1 AND f.field_value = 'aaa') OR (f.field_id=2 AND f.field_value = 'bbb')

Triexa.com — Fri, 17 Feb 2006 06:34:50 +0000

field_id references another table which has more information

but in my example.. 2 field_id's.. 1 and 2...

but I want the VALUE volumn of field_id's 1 & 2 to equal 'aaa' and 'bbb'... follow?

Greg K — Fri, 17 Feb 2006 06:24:33 +0000

From the query you have given, you are requesting that field_id be equal to 1 AND 2 at the same time and field_value be equal to 'aaa' AND 'bbb' at the same time.

I'm not exactly sure what you are wanting, but maybe replacing the middle AND with an OR ????

-Greg