CODEWITHSUNDEEP
mysqlmax
Stovi Ryžas Stotelėje
Stovi Ryžas Stotelėje

Reputation: 81

Need to get max value from database table

I'm trying to get max value from database but it doesnt work for me. That i did wrong whith it?

  $con = mysqli_connect($servername, $username, $password, $dbname);
 $query_for_com = "SELECT MAX(id) FROM Comments";
    $mysql_query5= mysqli_query($con,$query_for_com);
    while ($query_row_com = mysqli_fetch_assoc($mysql_query5)) {
    echo $id_for = $query_row_com['Id'];
}

Upvotes: 1

Views: 36

Answers (1)

teoreda
teoreda

Reputation: 2580

Try this approach:

$query_for_com = "SELECT id FROM Comments ORDER BY id DESC LIMIT 1";

Upvotes: 1

Related Questions