[Skunkworks] Mysql help

Hie People I needed some assistance with some SQL logic..is their a way i can filter the last 6 records that are inputed into a database dynamically.i am using the limit command but its static unless i am wrong. Thanks BA