php怎么输出mysql一条数据_如何使用PHP获取MySQL数据库表中的最后一条记录？

I want to fetch the last result in MySQL database table using PHP. How would I go about doing this?

I have 2 Columns in the Table, MessageID(auto) & Message.

I already know how to connect to the database.

解决方案<?php

$result = mysql_query('SELECT t.messageid, t.message

FROM TABLE t

ORDER BY t.messageid DESC

LIMIT 1') or die('Invalid query: ' . mysql_error());

//print values to screen

while ($row = mysql_fetch_assoc($result)) {

echo $row['messageid'];

echo $row['message'];

}

// Free the resources associated with the result set

// This is done automatically at the end of the script

mysql_free_result($result);

?>

The SQL query:

SELECT t.messageid, t.message

FROM TABLE t

ORDER BY t.messageid DESC

LIMIT 1

...uses the ORDER BY to set the values so the highest value is the first row in the resultset. The LIMIT says that of all those rows, only the first is actually returned in the resultset. Because messageid is auto-increment, the highest value is the most recent one...