Simple question? LIMIT and ORDER

[elstudion]

Hi!

First post here...
I need to get the latest added records from a MySQL DB and LIMIT the result to the _latest_ 10. And then I need to ORDER them by a field called 'rubrik'. I have a fild called 'date' that stores the date when the record was created. How do I do this?

.bobo - elstudion.

 

[tlbroadbent]

This is a Microsoft SQL Server forum. Post MySQL questions in forum463 - "T.C.X DataKonsult AB: MySQL" Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.