Hiya Tyler
As everyone else has suggested, I do too. Read the MySQL-manual. Not from
the start to the end, but the parts that you need. I'd look up the syntax
for SELECT and then find out what is possible to do with it.
I'll also recommend you an article about MySQL/PHP which was the one getting
me started (And I'm making a living of it actually!) :
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
A book worth reading would be : "MySQL" by Paul DuBois, which covers almost
every aspect of the MySQL-DB ...
Yours sincerly
Jacob "Techek" 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 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 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 check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
