Need a Gift Certificate Script

timhersh

New Member
I'm pretty sure there has to be a script for this out there but can't find it.

Basically I have a client who wants to be able to sell a gift certificate online, they will pay through paypal and then once the payment is made it will generate a gift certificate that the customer can print. The gift certificate will have a code (random number) that ensure the validity of it. The would redeem this gift certificate in store so somehow we need to have a way to access the giftcertificates that have been sold along with the code so my client can double check to ensure it was only used once.

Any ideas??
 

timhersh

New Member
MMWed

Quick Question. I am trying to install your script.

I added a new sql database called "item" then I went to add the SQL code (see below) and it gives me this error message
#1067 - Invalid default value for 'id'


this is the SQL code

CREATE TABLE item (
id int(11) DEFAULT '0' NOT NULL auto_increment,
item_name varchar(100) NOT NULL,
item_desc text NOT NULL,
item_hidden char(1) DEFAULT 'N' NOT NULL,
item_price decimal(5,2),
item_misc text,
item_size varchar(64),
URL blob NOT NULL,
item_vendor varchar(25) NOT NULL,
PRIMARY KEY (id)
);
 

emilyl

New Member
I have other projects coming up and would like to build a relationship with reliable person who charges reasonable prices.
 
Top