date

[sanu]

i want to display 5 topics as new among 1000s how is it possible

[keith73]

you can do that in your SQL statement.

SELECT * FROM news ORDER BY date DESC LIMIT 5

ORDER BY tells the DB to sort the results using the field date and DESC tells it to show the most recent first. LIMIT 5 tells it to only return 5 rows.

• Keith

[sanu]

if i use 'limit 5' it will only display 5 result serial wise but i want to dilplay all in the list and any 5 can be new according to the new posted and it might be order by NAME or any other
thanks