simple db question

Hi, is there a way to extract the last 20 records in phpMyadmin 2.3.2. I will use $row = mysql_query('SELECT ????????');

Then display the information on a web page:

while($results = mysql_fetch_array($row))
{
echo '{$results ['name']}';
}

Can somebody out there help me out? Thanks!

Take your select statement and order it backwards. I.e., if you had:

select * from table order by name

do a:

select * from table order by name desc limit 20

It works! Thanks alot!