Jump to content

RAND item


The Little Guy

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.