Hey there,

I'm developing a bonus points club system for a client, and need to know how , after the user has logged in to check their points, how they can then buy products from the product database and have their bonus points minused in the bonuspoints database ...

Or is there a better way ??

oh, i'm using d/w mx and msaccess databases and SQL - got the login,registration e.t.c. working fine - just coming un-glued on how to do the above ..

cheers, Angie in Nuclear Free New Zealand.

Edited by - designguru on 15 Sep 2003 04:13:45

Hey designguru,

How about having an UPDATE script on the purchase form, where you deduct the points value of the item purchased from the customer's total? This could be done via PHP or JScript and stored in a hidden field, which could then append the customer's total running points index upon submission of the form in question.

I hope that helps...

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN: