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? 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. Link to comment https://forums.phpfreaks.com/topic/205707-rand-item/#findComment-1076382 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.