Ok, here's the problem
I have, say for instance, a large music instrument retail site or something along these lines - high value items. Because of this there is a sales hotline so that people can phone in and hear someone's voice and take their details - thus offering reasssurance.
This is fine, but when they start asking loads of questions, normally whether we have an item in stock, the sales phone isn't taking sales, but answering queries etc.
I would like to tackle one of the most common, by indicating on our product pages whether an item is in stock or not - and if not, how quickly we can get one to the customer.
All our product pages are static, nothing being read out of databases - it really has been a labour of love! I do have MYSQL capability on the server - so I thought maybe I could list all our products in a table and if the number in stock is 1 or >1 then it prompts a message on the pages i insert some code into "in stock". Maybe have another column I could check if it is back in 2 weeks, and another one for "within 1 week". etc etc.
I'd be grateful if anyone has any experience of using anything like this, and how useful they found it. Also, remember my MYSQL and PHP experience is 0! So ideally i want to be able to insert a line of code that will be automatically updated when the "database" i don't mind what guise it takes, is updated.
Any ideas/Suggestions etc etc would be great.
And - no. At the moment I don't want the whole site to be database driven.