"Website - Inventory" Programmer's HELP needed

[astei2]

I'm using EXCEL - the fields are item # -
price - stock status (Yes or No). I have saved the
file as html and uploaded to site.

My question is how do I reference the table from each
individual product being sold so it returns a value of IN
STOCK "yes" or "no".


Any help would be appreciated. Thanks.

 

[astei2]

I think a more thorough explanation of what I want to do is in order. I want visitors to our site to have up to the minute in-stock status of items sold on our site.

I have uploaded the excel table containing the fields: Item # - Price - Amount in Stock
to my site to a page (such as) mysite.com/stock.htm

On all product pages (such as) mysite.com/clocks.htm (a page where a product is sold).............

What is the exact syntax I would use to reference the item of each product being sold and being looked up on the stock table at mysite.com/stock.htm and how do I reference it?

I'm using Frontpage and not sure how the formula is put into each page - can I just paste the formula into the html code of each page I wish to have an IN STOCK Status of?

Thank you -- hope to hear from someone soon.