1
Hi, I am trying to build a website for a football club that I am a sponsor of. I am doing this FREE for them. the website is still under construction. Its here:
http://www.auspcs.com.au/cometsI need some help with a couple of things Im suck on.
I have 3 questions, This may seem odd but I would like to know how to update 1 single table in the database with data from a .csv file.
I would also like to have a page showing this table sorted alphabetically from a drop down menu.
An example of this is here;
http://www.auspcs.com.au/comets/modules/content/index.php?id=14As you can see its a lot of data and the html page is quite large. I wanted to have these statistics in the database and show this page by reading the database. The CSV import is also needed as this data is updated oce per year and there are 000's of names (past players and new players)
So my questions ae:
1. How do I display the data sorted alphabetically in a nice page with a dropdown menu? (same as what I have above)
2. How do I export and import the MySql database table to a CSV file for editing.
3. Is this too big a task, I am trying the phpmyadmin module to see if that imports/export while I wait for an answer
I have a php script that does import a csv file to the database and it works (wasnt written by me) but its old and not tidy or easy and it wont export only import. You can see it working here:
http://www.auspcs.com.au/images/php_csv_importer_2/csv_importer/csv_importer.phpthe username etc will be sent via email to anyone that wants to try to help.
Thanks for any help you may be able to give me.