[Resolved] very easy question

[da_marek]

hi!
is there any easier way to select ONLY LAST record from database that this one:

$countsqlmp3s = mysql_query("SELECT * FROM mymp3s");
$countmp3s = mysql_num_rows($countsqlmp3s);
$mp3slimit = $countmp3s-1;

$sql = "SELECT DATE_FORMAT(datum, '%d/%m/%Y') AS date FROM mymp3s LIMIT $mp3slimit, $countmp3s";
$result = mysql_query($sql);

?

thanks!

[kevinsequeira]

select * from $tablename order by id desc limit 0,1

// id is the primary key of the table in this case
reg
kevin