Menu

How to add a song to the queue in SQL terms

2003-10-14
2003-10-15
  • Paul McCombs

    Paul McCombs - 2003-10-14

    I've been working on a custom interface to the jukebox player and database, in the form of PHP scripts.

    I've been mostly as an excercise in educating myself about using PHP and SQL queries. But also to give myself just the features I want.

    I've read through the php scripts supplied with the download, many times. Unfortunately it is over my head in many parts.

    I'm hoping that someone with a better understanding than myself can help me with what exactly needs to happen in the database, when a song is added to the queue, so that the ranking functionality is retained.

    I understand how to add a song to the queue. I understand where the rank value is kept in the database. What I don't understand, and can't find in the code, is how is the new rank value calculated.

    A pointer to the specific file that does the calculation would be appreciated in lieu of an explanation.

    Thanks for any help.

     

Log in to post a comment.

Auth0 Logo