assuming that u want to display the last 6 records, you can <b>order by id desc limit 6</b><br><br>this is assuming you have an auto incrementing column called id in the table. If you don&#39;t just <br><b>alter table {tablename} add id serial;</b><br>
<br>else u can have a timestamp column and sort id desc like above.<br><br>rgds<br><br>Muchemi.<br><br><div class="gmail_quote">On Fri, Sep 24, 2010 at 12:53 PM, Benjamin <span dir="ltr">&lt;<a href="mailto:anangwe@gmail.com">anangwe@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hie People <br><br>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.<br>

<br>Thanks BA<br><br><br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>

------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards<br><br><a href="http://www.software.co.ke">http://www.software.co.ke</a><br>------------------------------------------------------------------<br>
&quot;My Compiler Is My Life&quot;<br>