RE: most viewed

2001-04-01 Thread Tyler Longren
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

Re: most viewed

2001-04-01 Thread --==[bMan]==--
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

Re: most viewed

2001-04-01 Thread Steve Werby
"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