SQL MAX（）遇到问题

Question

Here is my code.

$sql2 = 'SELECT MAX(ASSIGNMENT_ID) FROM assignments';
$result2= mysqli_query($connection,$sql2);
$row2= $result2->fetch_assoc();
$assignment_id=$row2['assignment_ID'];

That is the best I have gotten it after many different iterations. I cannot debug this using the xhr.response because I keep getting"XHR failed loading: POST" console messages despite everything posting fine to my SQL database. Apparently that XHR error causes me not to get back any php messages back at all. This problem as a whole I've been stuck on for several hours- any help I would be very appreciative of.

Answer 1

$sql2 = 'SELECT MAX(ASSIGNMENT_ID) as assignment_ID  FROM assignments';

Than use your key $row2['assignment_ID']