Hello all,
I'm creating a Fantasy Football web and I have a couple of questions that I hope someone can answer. First, I will explain what I'm trying to do. I get a text file that I create will NFL player stats. I need to use that file to update the players database and run some calculations to determine the points and what team won.
My questions are.
1. I use phpmyadmin on my site but it does not do what I want it to do, that is import the text file, if there is an NFL player in the text file then update the record, if not then add the new record.
2. How do you move or delete a record from one table and insert it into another table. (this is done when someone add/drops a player)
3. I am getting better with PHP and Mysql but does anyone know of a good script I can use to display my reports (ex. Top 10, line-up ect.)
Thanks for your help
I'm creating a Fantasy Football web and I have a couple of questions that I hope someone can answer. First, I will explain what I'm trying to do. I get a text file that I create will NFL player stats. I need to use that file to update the players database and run some calculations to determine the points and what team won.
My questions are.
1. I use phpmyadmin on my site but it does not do what I want it to do, that is import the text file, if there is an NFL player in the text file then update the record, if not then add the new record.
2. How do you move or delete a record from one table and insert it into another table. (this is done when someone add/drops a player)
3. I am getting better with PHP and Mysql but does anyone know of a good script I can use to display my reports (ex. Top 10, line-up ect.)
Thanks for your help
