Welcome to WebmasterWorld Guest from 220.127.116.11
The spreadsheet has simple formula but a large amount of potential variables.
Alternatively, there is an Excel file parser availabe from [hotscripts.com...] (havn't used it)This parser program can import data from an Excel file, versions from Excel 5.0 to Excel 2000 and XP....
If I'm off the beaten track explain a bit further please.
I was just curious if I was going about this right way as it involves a considerable amount of work.
If not then go for it, I have made a few things like that for our intranet. They are a lot of work but are very satisfying because they are usually complex.
I have already started with some success but my first obstacle is user registration with mySql. I need the user to come back and access the data they inputted last time. I have done some mySql work but never for more than one user so I have just used htaccess on the directory. I need the individuals to gain access to only their own records. Can this be done securely on one database? I will issue user names and passwords myself.
I would be grateful for your advice.
Another way around the problem would be to write your code to carefully restrict your selects to the data that the current user has access to. It's probably not as efficient as using different database users, but as long as the control is very loose you might find it enough easier to implement that it's worth it.
I'm thinking of perhaps switching from a single-database-user to multiple-detabase-users with my pet project, though I probably won't get to it for a few months because there are other features I want to implement first. If you're interested, I can sticky you or write a post about it when I get there. (Its a PostgreSQL based project, not a MySQL based one, but at least some of it will probably transfer.)