如何将mysql查询中的max id存储到php变量中？

Question

This isn't working for me:

$query = mysql_query(" SELECT max(id) FROM chat_records ");
while ($row = mysql_fetch_assoc($query)) {
    echo $row['id'];
}

How can I get it to work?

Answer 1

Change your query to this:

SELECT max(id) AS id FROM chat_records