Obsolete parts list

  ktheed1 09:19 AM 15 Oct 10
Locked

Hello,

I wish to create the follwing:

1, A greeting page asking for an obsolete part number.

2, When user enters the obsolete part number the webpage will then consult an excel file that has two columns "Old Part" and another column called New Part. (Mainly to make it easy for updating on a weekly basis).

3, Once the user clicks submit after entering the part number, the webpage will consult the excel spreadsheet and return the new part number so the user knows what the replacement part is.

Any help to do this would be appreciated, It should be quite simple but its knowing how to do it.

I dont have any knowledge of PHP and MySQL but would prefer it to be in this format if possible as that is what I have on my test web server at home.

Many thanks
Kieron

  ktheed1 09:20 AM 15 Oct 10

It would be good aswell so if the user enters half of the part code then it will show the results with all parts starting with the relevant letters/numbers entered.

Advertisement

This thread is now locked and can not be replied to.

How to get free stuff for Android: Amazon Underground offers genuinely free Android apps and free…

1995-2015: How technology has changed the world in 20 years

Swedish schoolkids use Minecraft to redesign Stockholm city centre

Apple's special event invitations decoded: A look back at 13 of Apple's most cryptic invites