Technote Details :: Display only the latest records

When publishing only the latest news to your RSS feed, you have to limit the number of records.

Limiting the number of records must be done in order to display only the latest news, or other RSS items.

To limit the number of records, you must add SQL clauses to the recordset. Depending on your database server, you can use a query like the following to display the latest 10 records:

MySQL

SELECT * FROM [rss_table_name]
ORDER BY [rss_date_column] DESC
LIMIT 0,10

MsSQL/ACCESS

SELECT TOP 10  * FROM [rss_table_name] ORDER BY [rss_date_column] DESC

Login to add a new note