CSV fixed format to mySQL database - is this possible?

Hi there,

I have a rankings page for my poker site that pulls information from a mySQL database that I have had created for me. I have to go in and update manually the resullts via a web form. (http://www.sussex-poker.co.uk/index.php?categoryid=22)

Is there a way to have this information pulled from the created CSV into the database automatically?

If so could any one help and supply a quote for the work?

Many Thanks

Skelly

 

Sure there is a way, a little PHP script would do what you need.
It can be very small or more complicated, depending on other functions you may want (remove bad characters if needed etc). You could search some freelancer sites, i believe they would do such script for not more than $20-25

 

Hi Skelly,

The LOAD DATA INFILE command will load a CSV file into a MySQL table. See http://dev.mysql.com/doc/refman/5.0/en/load-data.html for details.

HTH

 

I would gladly create this for you.

I only need access to the server and I can create a simple job to run as frequently as you want to upload the data into the database.

PM me.

 

PM sent to littlejohn thanks to everyone else for their replies.

Skelly