|Posted: Friday Jul 6th, 2012 at 2:57 pm #18498|
Hi all, I’m doing some s2member custom code that includes some buddypress fields, I need to order by a meta_value field and I’m stuck :(
Its not an s2 field I want to order by but you guys are so smart and helpful I was hoping you’d spot the answer to my problem…
Here’s my query:
I need to order by UMMD.meta_value which contains a date, so I’ve used my WHERE to dig out the correct meta_value field based on its corresponding meta_key. However, the order by doesn’t work – if I change the top line to SELECT DISTINCT(U.ID) as `ID, UMMD.meta_value it works, but it also duplicates my results as it seems to ignore the DISTINCT on the U.ID field…
I’m stumped, I’ve tried all sorts – please help!!
- s2Member® Products