Page 1 of 1

"single use" coupon

Posted: Tue Dec 23, 2003 10:13 am
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

Posted: Tue Dec 23, 2003 11:59 am
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.

Posted: Tue Dec 23, 2003 12:03 pm
by glennn3
ok - and then an if statement at the submission page which will not allow access if "0", right?

thanks

Posted: Tue Dec 23, 2003 12:34 pm
by microthick
Exactly.

Best of luck.