Obsolete parts list

  ktheed1 09:19 AM 15 Oct 10


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

  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.


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

Best Cyber Monday deals 2015 live blog: Best UK Cyber Monday tech deals, sales, discounts & offers

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

Harry Potter's graphic designers showcase magical props & posters in new exhibition

Apple rumours & predictions 2016: What to expect from Apple in 2016