Hey,

I have a section on my site for news articles. On the home page, it displays the latest article from the database.

The SQL that powers this is simply:

SELECT * FROM tbl_News ORDER BY nws_Date DESC

The code then just picks the record that the pointer is currently on, and displays it.

What I was wondering, is if there's a way to only select the last entered record in the DB, so that the SQL Statement doesn't return the entire table, which could be a significant performance hit once more than a few news articles have been added?

you could do this:

SELECT TOP 1 * FROM tbl_News ORDER BY nws_Date DESC

That works great, thanks!

To know the last record id when you are inserting a new row, use

SELECT @@identity

Also read the @@identity crisis

That only works with SQL Server and is not what Minaki is looking for. It is, however, a great tip that people tend not to know.

It works with MSAccess too.

Oh it does? My mistake, thank you for correcting me.

Actually... I was using a less effective way of getting that value and was about to ask if there was a better way of doing so...
Thanks again!