Need to do a simple lookup...

[TTJOY]

Hi - I'm new here and I know next to nothing, and I'm not even sure if I am asking about PHP or mySQL or both... please bear with me.

 

I have a spreadsheet with three columns of data.  I need to be able to have a user go to my website and enter a number and have it searched in the first column, and return the data in the 2nd and 3rd columns.

 

It does not need to be password protected or anything fancy.  Just a simple lookup function, and maybe a message that says "there is no record of that number" if there is no match.

 

I have a basic understanding of HTML and I am comfortable with uploading to my web server (1and1).  I know I have mySQL 4 and 5 databases available to me.  What I need help with is understanding how to upload this spreadsheet info to a database and how to write a script that will generate a page that will request the number, and then return the data.

 

Is this impossibly complicated -- can I learn it or can I pay someone to write it up for me?

 

Thanks for your consideration!

Joy

 

[chronister]

Your asking about php & mysql as php will do the heavy lifting of taking a csv and then inserting it into a mysql db

 

http://www.phpfreaks.com/forums/index.php/topic,156812.0.html

 

The post above is one I made that has code for a form to take a csv file, make an associative array and insert it into a db.

 

That is the first part of your issue, the second would then be the form to accept the data that PHP will then make some DB calls and search for the inputted data.

 

I would be willing to write it for you for $$. If you are interested, check my profile and hit me with an email and we can discuss it further.

 

Nate

[Dethman]

Ill do it for free hit me up on msn and yahoo

 

Msn: [email protected]

Yahoo: [email protected]