PHP w/Text file?

[Neebski]

hey there, im trying to make a page where a php script will upload a text file then take the two coloums "id and balance" and update a database. If anyone has an idea let me know thanks.

[Twey]

Don't suppose you feel like giving any details?
Format of the text file? Database software?

[Neebski]

haha sorry, looking at somethings now it looks like it would be easyer to use an excel sheet with the same coloums.

but I really dont know, I have never tryed this, what would your opinion be?

right now im running mysql on a windows server.

Thanks

[Twey]

I don't know anything about Excel, but my instinctive reaction is to say that you should go with a simple text file rather than attacking the rather knotty problem of the binary Excel spreadsheet that probably contains massive amounts of data (formatting and so on) that you don't need, which would make the whole process complicated and inefficient. Another option you might want to consider is making use of PHP's XML support.

[Neebski]

wow, thats complicated...

im still a nob at xml so umm where do I start?

[Twey]

http://www.w3schools.com/xml/default.asp