select * from Products order by Visited desc limit 10; should give you the top 10 products.
On 9/5/07, Tomas Abad <[EMAIL PROTECTED]> wrote: > > HI All, > > > > I have a Table and want to know the most visited products. > > > > Products > > - Id > > - Name > > - Visited > > > > Visited is numeric. > > -- Thanks Alex http://alexlurthu.wordpress.com
