[UPHPU] adding a count to an MySQL query

Wade Preston Shearer wadeshearer.lists at me.com
Thu Dec 24 11:26:42 MST 2009


On 24 Dec 2009, at 11:18, Randy Moller wrote:

> You could use a group by based on the event location to get the  
> count by group.

That's closer, but the subquery now returns multiple rows. I still  
need a way to only select the rows (for the count) from the many-to- 
many table for events users are registered for that match the row  
currently being selected from the main query

I need a meev.meev_even_id=even.even_id somewhere.




More information about the UPHPU mailing list