Question 41502 in PHP Question posted in
Official manual can be found here.

how select from the database where the colum has the highest value in a table in sql – PHP

i have this table that has some data, but i want to get the row where a paticular coluom votecount has the highest value:

id votecount
1 0
2 1
3 1
4 13

i tried this sql statement:

$selectr = "SELECT *, MAX(`votecount`) from `audio`"; 
$stmt = $conn->prepare($selectr);
$stmt->execute([]);
while($row = $stmt->fetch())
{
    $userid = $row["id"];
    $votecount = $row["votecount"];
    echo $userid;
    echo $votecount;
}

but it echos out 10 which means it got the first item in the table and the value is 0, which is wrong, its not getting the highest column

so how do i fix this

Tags:

2

Answers


  1. 0

    Try correct: $userid = $row["userId"]; to $userid = $row["id"];

    Login or Signup to reply.
  2. 0

    Try this:

    $selectr = "SELECT * from `audio` where `votecount` = ( SELECT MAX(`votecount`) from `audio`)"; 
$stmt = $conn->prepare($selectr);
$stmt->execute([]);
while($row = $stmt->fetch())
{
    $userid = $row["id"];
    $votecount = $row["votecount"];
    echo $userid;
    echo $votecount;
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search