Re: FN-FORUM: MySQL/PHP question

date posted 23rd July 2007 00:02

hello,

If you want to show only say top 4 rows
use something like
SELECT TOP 4 OrderPrice
FROM Orders
Order by OrderPrice DESC

or

If you want to show only say lowest 4 rows
use something like
SELECT TOP 4 OrderPrice
FROM Orders
Order by OrderPrice ASC

Or do you you want to retrieve only 4 records at a
time?

Regards
Ah




___________________________________________________________
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html