select * from Products order by Visited desc limit 10; should give
you the top 10 products.
On 9/5/07, Tomas Abad <informatica@vipventa.com> 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