简单查询不起作用？

Question

I am trying to get a single value from the database. Somehow it does not echo out. I know about the security deprecation and will use PDO later on this is just as test. I filled in the correct table. When I use the sql I have in phpmyadmin it correctly gives me the value i want.

  <?php
    include 'connectdb.php';

    $result = mysql_query("SELECT id FROM table ORDER BY id DESC LIMIT 1");

    $row = mysql_fetch_row($result);


    echo $row["id"];

    mysql_close();

   ?>

Answer 1

per the docs ->mysql_fetch_row — Get a result row as an enumerated array http://php.net/manual/en/function.mysql-fetch-row.php so you want

echo $row[0];

--
note: also from the docs -> Warning [mysql_ functions/] extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information.