PHP，选择+1不能在mysql中工作[关闭]

Question

So this keeps still returning 1 (the max is 1), when I run the query in phpmyadmin I get 2.

function getListingID(){
global $servername, $username, $password, $dbname;
 $conn = mysqli_connect($servername, $username, $password, $dbname);

 $result = $conn->query("SELECT 1, MAX(position)+1 FROM listings");
 $row = mysqli_fetch_row($result);

return $row[0];
}

Any help is appreciated. Thanks!

Answer 1

You should return the index 1 for get the MAX(position)+1 (second column index = 1)

return $row[1];