"single use" coupon

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

"single use" coupon

Post by glennn3 »

i have a need to offer my clients a "coupon" single free submission (manuscripts at a literary magazine site) for their paid subscription to be used whenever they want to redeem it, followed thereafter with paid submissions - i of course need to limit their use of this coupon to one use.

i'm certain this concept has been realized and implemented before. is there anyone who might point me to a script that might offer the ability to do something like this?



thanks for anyone's ability to understand my cryptic request and offer help.

:o)
glenn
microthick
Forum Regular
Posts: 543
Joined: Wed Sep 24, 2003 2:15 pm
Location: Vancouver, BC

Post by microthick »

A quick google search returned nothing useful.

But this should be fairly easy for you to implement.

You could create a database table with two columns:
coupon_num (varchar)
valid (enum or int representing Y and N or 1 and 0)

When they use the coupon, changed the value of valid to N or 0.
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

Post by glennn3 »

ok - and then an if statement at the submission page which will not allow access if "0", right?

thanks
microthick
Forum Regular
Posts: 543
Joined: Wed Sep 24, 2003 2:15 pm
Location: Vancouver, BC

Post by microthick »

Exactly.

Best of luck.
Post Reply