calculations on dynamic rows

[kiwieur]

People,
I am not even sure if this can be done and this is why I am asking the initial question.

I have a web page that displays data in a table from a databse however the number of rows can change based on the criria selected.

I have a column that shows the order qty for a particular specification however there are 2 types of order

1. make product for stock
2. call off order from stock

such as

specification order type order qty
12345 make stock 10000
12345 call off stock 5000

what i would like is to have another column that shows current stock like so

specification order type order qty current
12345 make stock 10000 10000
12345 call off stock 4000 6000
12345 make stock 5000 11000

is it possible to recreate this so that it looks at the current stock on the line above and depending on the stock type either adds or deletes the order qty to the relevant row field.

sorry if i have not explained this properly.

any help would be much appreciated





Regards

Paul

 

[BillyRayPreachersSon]

This is very possible, however, given you've got server-side scripting to read from a database, I'd suggest doing this server-side rather than client-side.

Hope this helps,
Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Tech Snippets & Info:

http://www.codecouch.com/

 

[kiwieur]

Dan,

thanks for your reply, could you point me in the right direction for doing it server side please

Regards

Paul

 

[BillyRayPreachersSon]

Presumably the best place would be the forum for whatever server-side language you are using, e.g. ASP, JSP, PHP, etc.

Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Tech Snippets & Info:

http://www.codecouch.com/