Question on sub-selects

2004-01-28 Thread Deven Phillips
Hello, I have a question that someone here may or may not be able to answer (I think perhaps MySQL is incapable of a solution). I have a program which uses a MySQL database to help create a playlist for a ShoutCast stream. There is a web site associated with the web-radio. Users of the

RE: Question on sub-selects

2004-01-28 Thread Jeffrey Smelser
Hello, I have a question that someone here may or may not be able to answer (I think perhaps MySQL is incapable of a solution). I have a program which uses a MySQL database to help create a playlist for a ShoutCast stream. There is a web site associated with the web-radio. Users

Re: Question on sub-selects

2004-01-28 Thread Tobias Asplund
On Wed, 28 Jan 2004, Deven Phillips wrote: Hello, There is a web site associated with the web-radio. Users of the web site can rate songs which are contained in the database. The rating system works such that users can rate songs from +3 to -2. Now, what I would like to accomplish is to