BuddyPress.org

Any ideas anyone?

I’ve been there all day lol!

my logic in my $sql statement above was that I want to return a table where all those cases are true, and then count the rows where there are more than 1 instance of the same user_id, meaning it matched both arguments…however, the code I wrote above didn’t work this way…perhaps I’m just writing it […]

@r-a-y I’ve actually already tried that exact SQL query (it seems to make logical sense at first glance) but it doesn’t work because the “AND” statement is trying to make 2 different rows with different values match…which, obviously they don’t. They share a common user_id, but not field_id or value…thus being the problem.

@r-a-y Actually the problem is that the data is on the SAME table…not a different one…if it were different tables this would be easier 🙁

Since I’m being ignored, I’ll try adding more info… bp_xprofile_data table: id | field_id | userd_id | value ——————————————– 1 | 2 | 30 | General 2 | 3 | 30 | Female 3 | 4 | 30 | Los Angeles 4 | 2 | 32 | Premium 5 | 3 | 32 | Female […]

A tip or URL leading me in the right direction would be more than enough!

Anything, anyone?