Select last record in the database

[mrgrammar]

I need to select the last record in a table. What is the query?

table = xyz

The data from this one row needs to be echoed on the page. Rather than have to write out every field, I'd rather have it just take each field's data and echo it on successive rows. How do I make it automatically do this?

Ex:

Fieldname1: Fielddata1
Fieldname2: Fielddata2

and so on.

[HalfaBee]

If you have an indexed col. you can do "SELECT * from TABLE ORDER BY indexed_colname DESC LIMIT 1"

The use

$row = mysql_fetch_assoc( );
foreach( $row as $field => $data ) {
echo "$field: $data<br>\n";
}

[void_function]

More precisely, order by PRIMARY KEY.