Displaying Data from And Writing Data To MySQL Database

Hello everyone. I just registered and I've got a bit of a problem. I have a database already created. I will be manually adding more of the records to the database but one of my fields for each record is rank and I want to place a buttons on my website so the visitors can like songs and I want that rank field to increment by 1 every time the button is pressed. I also have a tab box on the home page where I want to query the database and display the top 10 songs by rank. Finally I want to display a random song name every 10 seconds.

Now I'm comfortable with html and css but totally clueless when it comes to php and javascript. I thought it would be easy enough to find a tutorial or website that would walk me through doing this. Unfortunately every site I've looked at assumes the user has some understanding of php. It's all a bunch of letters and symbols to me. I was wondering if anyone knows of a site that would show me how to do this. I mean I need to be told the exact code and where to put it on my page. everything from how to connect to the database to updating it and pulling data from it to display on my site. I'm sorry for the wall of text. Thanks for taking time to read this.

 

Why did you post your question here? It looks to me that it should be in the sub-forum for MySQL.

 

You should first understand php and mysql seperately. Then you just need to connect the dots. Nobody will write out the code for your application:

for php start here: http://www.w3schools.com/php/

make sure you understand sql: http://www.w3schools.com/sql/

then learn to connect to mysql from php: http://www.w3schools.com/php/php_mysql_connect.asp

From this point on you should be able to figure out things by yourself.

Hope this helps,