The Little Guy Posted June 24, 2010 Share Posted June 24, 2010 I have 2 tables: a. phrases b. answers I left join the two tables, and I would like to select all the phrases with the least amount of answers, and from those answers select a random phrase... So, I have this: SELECT *, COUNT(a.answer) as total FROM `phrases` p LEFT JOIN `answers` a ON(p.id = a.phrase) GROUP BY a.answer ORDER BY total The problem is that it shows everything, I just want the lowest totals, then select one random item from those. How can I do that? Quote Link to comment https://forums.phpfreaks.com/topic/205707-rand-item/ Share on other sites More sharing options...
fenway Posted June 24, 2010 Share Posted June 24, 2010 I don't follow. Quote Link to comment https://forums.phpfreaks.com/topic/205707-rand-item/#findComment-1076382 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.