[PHP] Getting the last record in a mysql table

[hugh danaher]

Help!
I thought this would be easy but it ain't.  What I want is the id number of the last 
record in a table.  I've tried a number of variations to the following but am getting 
no where!  Any help will be greatly appreciated.
Hugh


$results=mysql_query(" SELECT last_insert_id() FROM MY_TABLE ");
 $row=mysql_fetch_assoc($results);
 while ($row=mysql_fetch_row($results))
  {
  print "<tr>";
  foreach($row as $field) 
   {
   if ($field=="")
    {
    $field="&nbsp;";
    }
   print "<td align=center><h5>".$field."</h5></td>";
   }
  print "</tr>";
  }
 print "</table></td></tr></table>";