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)"; Quote Link to comment 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"; Quote Link to comment 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.