ek" Kamp Hansen
- webmonkey at Portaltjenesten A/S (dk)
-Oprindelig meddelelse-
Fra: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sendt: 1. april 2001 23:23
Til: MySQL List
Emne: most viewed
I've got a table that contains a list of bands. There's a field named
views. This field contains how ma
"Tyler Longren" [EMAIL PROTECTED] wrote:
I've got a table that contains a list of bands. There's a field named
views. This field contains how many times each band's page has been
viewed.
Ex:
id artist views
1 No names 6
2 WISH 10
3 Deftones 45
What's the SQL to select the
45
What's the SQL to select the top 2 most viewed bands(which would be WISH
Deftones)? I've tried a few things, but haven't gotten anything to work
correctly for me. Thanks.
Tyler Longren
-
Before posting, please
PROTECTED]]On Behalf Of
--==[bMan]==--
Sent: Sunday, April 01, 2001 4:37 PM
To: Tyler Longren
Cc: MySQL List
Subject: Re: most viewed
You should definitely read up the manual. If you don't do this, will not do
you homework and simply expect an answer handed down to you, you might get