How do I show the first X resaults from a Table?

[DrewM]

Well I'm making a new news system and on the home page I only want it to show the first 5 or 6 results. Can some one help me do this?

[filburt1]

<a href="http://dev.mysql.com/doc/refman/5.0/en/select.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/select.html</a>

Look at the LIMIT clause.

[DrewM]

thanks

how do I do this with vb?