coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: sgtpepper on January 30, 2004, 11:21:41 PM

Title: storing ecard recipient info in database....
Post by: sgtpepper on January 30, 2004, 11:21:41 PM
Hello,

I am trying to store the recipient name and email from the ecard in my database.

I have created a table called 'recipients' and added fields from name and email.

in ecard.php my lines 101 and 102 are


$result = cpg_mail($recipient_email, $subject, $message, 'text/html', $sender_name, $sender_email);
    $result = mysql_query("INSERT INTO recipients (name, email) VALUES ('$recipient_name', '$recipient_email'");


This isnt working....can you suggest what I need to do to store this data in the table?
Title: storing ecard recipient info in database....
Post by: sgtpepper on February 02, 2004, 07:45:31 PM
Can anyone offer a way that this can be done?
Title: storing ecard recipient info in database....
Post by: Nibbler on February 02, 2004, 08:18:55 PM
Your brackets aren't balanced.

$result = mysql_query("INSERT INTO recipients (name, email) VALUES ('$recipient_name', '$recipient_email')");
Title: storing ecard recipient info in database....
Post by: sgtpepper on February 02, 2004, 09:43:06 PM
That did it....it works great....thank you....