PHP & MYSQL - Song voting
Posted: Mon Mar 08, 2010 6:01 am
Hi everyone.
As a new person to PHP any MYSQL I'd like to request help, mostly request a path where to take off. Here is what I wish to do, and what I have:
-There is a song list in a .txt file (playlist.)
The playlist would be shown through php on a page. Users getting to that page would be able to vote on the tracks by clicking on them. Each day at a certain time the top songs would be saved to a .txt file. The votes would be tracked monthly and yearly too.
As far as I understood it would be easier to do this with SQL, rather than doing it with a plain txt file. In this case the .txt file needs to get to a MYSQL database, and reverse.
The idea is pretty fresh, so any other ways are welcome to do this.
The main idea is to make a voting mechanism on songs in a playlist, which can be saved in a .txt file in the order voted.
Thank you in advance.
As a new person to PHP any MYSQL I'd like to request help, mostly request a path where to take off. Here is what I wish to do, and what I have:
-There is a song list in a .txt file (playlist.)
The playlist would be shown through php on a page. Users getting to that page would be able to vote on the tracks by clicking on them. Each day at a certain time the top songs would be saved to a .txt file. The votes would be tracked monthly and yearly too.
As far as I understood it would be easier to do this with SQL, rather than doing it with a plain txt file. In this case the .txt file needs to get to a MYSQL database, and reverse.
The idea is pretty fresh, so any other ways are welcome to do this.
The main idea is to make a voting mechanism on songs in a playlist, which can be saved in a .txt file in the order voted.
Thank you in advance.