Multiple Inserts help needed

[kamy99]

Hi all:

I have designed a backend application to update our catalogue. Everything works fine, except lately we've changed part of the structure so I need to re-write part of the app.
I have a
Products(ProductID, Name, Price, Description)
Categories(CatID, Name, Description)
CategorizedPrices(ProductID,CatID)

The purpose of CategorizedPrices table is that we can have a product going into many different categories.

My problem:

I need to create an interface that allows for insert/update/delete any given product from the CategorizedPrices table.

I guess I need to use arrays or a for loop, but I'm stuck!
I'm only stuck with this part. Everything else like inserting/deleting/updating products and categories into db works like a charm. 😃

Any suggetions?

[stolzyboy]

what is the difference in i/u/d the categories as opposed to the categories prices, it will still be a simple i/u/d

[kamy99]

Sorry that was a typo!
It should be CategorizedProducts
:o :o :o

[stolzyboy]

regardless what it is called, you can select all the categories, then select the certain one, fill the info into a form and update it, delete it whatever, should just be the same as any other insert/update/delete or is there something weird going on, maybe post some code if you started on something