[baw]

I'd like to create a webpage (probably would be php script and mysql?) that I could upload a .csv file. And then setup a query and then run this query and have the page return the results of the query.

I've used php and mysql over the years but I don't have the knowledge to start this from scratch. If someone could point me in the right direction, that'd be great.

[baw]

Not finding what I want on the web, so I'm going to go it alone. Firgure I'll start small first and accomplish basic things first.

Code:
Choose file to upload -> Check table for old data -> Delete data in table if found -> Insert new data from CSV file into table

[ralph4208w]

Here's my 2-cents on the topic...

Take a look at phpmyadmin....you'll be able to see some samples of php code implementing table creation and dba scripts on a db. Your first task would be to interpret the csv file and use the first line as the "header" row. Create a new db table with the columns identified by the header row. Then, do inserts of the data into your new table. You can then run sql queries against the table. Some may say use arrays and memory, but then you may run into problems intepreting and processing your own queries against data stored in memory. By creating a db table with the data, you'll at least be able to leverage the sql language.

Good luck!