Querying

[Scot Lester]

Hi

I am new to all this SQL stuff. But I am learning slowly.

I have a database with a lot of products in. I need to be able to run a statement (from a web page if poss) that will grab certain products by code, e.g. everything that starts with "TR??????" and then change all there prices either up or down a specified percentage?

Can this be done? and if so can you point me in the correct directions? or show me the code?

lamens terms:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
if products = "brx?????" then increase price by "10%" or decrease size by "10%"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I would like a web page that has a text box to enter product code and a text box for +- percentage?

Am I asking to much? can this be done?

Many thanks in advance for any help.

Regards

Scot