violinrocker Posted March 28, 2011 Share Posted March 28, 2011 I want to get the top 5 rows with common keywords how can i do this? its like this $query = "SELECT adder,min(title)FROM shsh group by adder order by mysql_num_rows($q)"; Link to comment https://forums.phpfreaks.com/topic/231943-order-by-msql_num_rows/ Share on other sites More sharing options...
mikecampbell Posted March 28, 2011 Share Posted March 28, 2011 $query = "SELECT adder,min(title),count(*) as ct FROM shsh group by adder order by ct"; Link to comment https://forums.phpfreaks.com/topic/231943-order-by-msql_num_rows/#findComment-1193348 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.