Showing only the top 5 results

Showing only the top 5 results

Sorry, I'm rubbish at php but I am willing to learn.
I'm creating my website found here
and am creating a page called more.
Within this page I want to add a list of my top 5 promotions on my site.
Each promotion is saved in my mobi database in mysql and I have added a
count for each time someone views a particular promotion on my single.php
page.
So basically. What I need to do is display 5 promotions with the highest
number in the "views" field in my mobi database.
I currently have these codes:
include_once('include/connection.php');
include_once('include/article.php');
and
<?php foreach ($articles as $article) { ?>
<a href="list.php?id=<?php echo $article['promo_title']; ?>"> <?php echo
$article['promo_title']; ?> </a>
in more.php and also
class views {
public function fetch_all(){
global $pdo;
$query = $pdo->prepare("SELECT * FROM mobi ORDER BY views DESC LIMIT 0, 5");
$query->execute();
return $query->fetch();
}
}
in articles.php which only loads some weird text of "t t t t h h w w d d d
d 3 3"
I think I need to ad an array of some sort but I'm not sure how to type it.
Please can someone advise me on how?
thank you.