Hello
I have made code but it doesn’t work right
i want it show me top4 popular videos from videos table
Videos: v1 - 5 views , v2 - 7 views , v3 - 10 views , v4 - 8 views
i want it order it by views like
TOP4
V3 - 10 views
V4 - 8 views
v2 - 7 views
v1 - 5 views
my code
[php]
$popular = mysqli_query($conn, “SELECT id,title,season,episode,views,link,img,date FROM videos ORDER BY views DESC LIMIT 4”);
while($row = mysqli_fetch_assoc($popular)) {
[/php]
i dont know why but sometimes it works when i go to video watch it it get more views and order is not right , it is not ordering right i mean it starts to order like
TOP4
v1 - 5 views
V4 - 8 views
v2 - 7 views
V3 - 10 views
or something…