How to select last id from sql table?

Question

PHP

I need to select the last assigned id from the database when loading the page. Ids are assigned automatically. In phpmyadmin, the code works, but it does not display data on the page (Id must be displayed not on the registration page). Here is my code:

$sql = "SELECT LAST_INSERTED_ID FROM members";
  while ($row = mysql_fetch_assoc($sql)) {
    echo "<span class='num'>" + $row['id'] + "<span>";
  }

Answer 1

SELECT MAX(`id`) FROM `members`

Answer 2

"SELECT id FROM table ORDER BY id DESC LIMIT 1"

Answer 3

PHP has a function like mysql_insert_id . I think this is what you need.
PS I beg you, do not use outdated database functions. On kraynyak - mysqli extension. And ideally - PDO

Answer 4

Nothing happens. The page loads without errors, but the result is not displayed anywhere.

Answer 5

$sql = "SELECT LAST_INSERTED_ID FROM members";
$sql = mysql_query ($sql);
  while ($row = mysql_fetch_assoc($sql)) {
    echo "<span class='num'>" . $row['id'] . "<span>";
  }