email-can this be done?

aviendha

I have a form that sends info from the user to a MySQL database. When the info is sent I need it to also send some of the info in an email to me. I can write to the db and send an email to me from the user, but I can not get more than 1 or 2 variables in the body of the email. (This is based on a trial table - the actual table, members, will have many more columns.) When I try to send them all there are too many parameters. When I do the following code the body of the email just says 1. I would prefer not to use an attachment if possible. Thanks in advance.

$query="insert into guests values (' ','$Name', '$Email', '$Comments')";
$result=mysql_query($query, $link);

mysql_close ($link);

mail( "my email", "New Guest",
$result, "From: $Email" );

planetsim

What exactly are you trying to do..

if your trying to send what you are inserting into the database try this

$message="New Guest. $name
$comment";

mail($to,$subject,$message,$from);

try that

aviendha

Thanks planetsim for your reply, if only I had asked you yesterday when I started working on this. I actually figured it out about 10 minutes ago & just finished testing it. Figuring something out is one of the best feelings. I hope it never stops happening. I solved it just a little differently, like this:

mail( "my email address", "New Guest",
"Here is the data from the form:

The New guest name is: $Name.

The new guest email is: $Email.
The new guest comments were: $Comments",
"From: $Email" );

It's amazing that something so small stumped me for 2 days. I always get stuck on the easy stuff-I tend to overanalyze things.

Thanks again,
Aviendha