如何在数据库中选择前三行的帖子

Question

I have created a posting system along with a liking system. I wanted to select the top three posts with the most likes but I don't know how to do that.

I have this code but I can't figure out how to select more than just one row.

$get_pop_posts = mysql_query( "SELECT MAX( likes ) AS popular_posts FROM `posts`;" );
while($fetch_pop_posts = mysql_fetch_array($get_pop_posts)){
    $pop_posts = $fetch_pop_posts['popular_posts'];

    echo $pop_posts;
}

this piece of code only fetches one row from the database.

Answer 1

SELECT *
FROM posts
order by likes desc
limit 3