1
hoppy
CSV export and import
  • 2007/4/6 19:39

  • hoppy

  • Just popping in

  • Posts: 6

  • Since: 2007/3/21


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/comets
I 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=14

As 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.php
the 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.

2
hoppy
Re: CSV export and import
  • 2007/4/7 10:33

  • hoppy

  • Just popping in

  • Posts: 6

  • Since: 2007/3/21


Ok, I have done all what I asked on my own. My new problem is trying to get my little pull down menu to work in my content module. its 2 files ( 1 html and 1 php) when i run it it opens in the same window but without the rest of my site (like a new window but the same one). I want it to display in the window it stared in.

Any ideas?

a link to my pulldown menu: http://www.auspcs.com.au/comets/modules/homepage/content/select.html

I want this to be in my site, not on its own.

Login

Who's Online

275 user(s) are online (129 user(s) are browsing Support Forums)


Members: 0


Guests: 275


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Aug 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits