assuming that u want to display the last 6 records, you can *order by id desc limit 6* this is assuming you have an auto incrementing column called id in the table. If you don't just *alter table {tablename} add id serial;* else u can have a timestamp column and sort id desc like above. rgds Muchemi. On Fri, Sep 24, 2010 at 12:53 PM, Benjamin <anangwe@gmail.com> wrote:
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
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards http://www.software.co.ke ------------------------------------------------------------------ "My Compiler Is My Life"