EMAIL 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
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
disappointed. Question you have asked is like MySQL 101. To get you started
this time, however, here it is:
select * from table bands order by
"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