Hi,
Is it possible to order by a 2nd query count?
I am displaying one mysql table with a standard select query, but I need to order the results by the number of votes each listing has (which is from a 2nd table “votes”)
Is this possibe?
Thanks
Hi,
Is it possible to order by a 2nd query count?
I am displaying one mysql table with a standard select query, but I need to order the results by the number of votes each listing has (which is from a 2nd table “votes”)
Is this possibe?
Thanks
Yes, join the two tables, group by the first table’s id, and order by COUNT(*)
Thanks. Can I grab an example?
Scratch that, got it