mail(); after 'INSERT INTO TABLE'...

[glennn1137]

this function is called from a Subscription form, clearly - i'm trying to send an email to the $name and $email address after a person registers,
just after 'INSERT INTO MEMBERS...' but for some reason the mail(); function doesn't work no matter where i put it. can someone please help?

trying to mail(); the $name and $email after "insert into table" - it doesn\'t work for some reason... insert works fine but the mail(); doesn't. anyone help?

if($function=="subscribe")
{
	$name=$_POST["name"];
	$lastname=$_POST["lastname"];
	$street1=$_POST["street1"];
	$city=$_POST["city"];
	$state=$_POST["state"];
	$zip=$_POST["zip"];
	$country=$_POST["country"];
	$email=$_POST["email"];
	$username=$_POST["username"];
	$password=$_POST["password"];
	$narrative=$_POST["narrative"];
	$nn=$_POST["nn"];
	$ws=$_POST["ws"];

$fields=array($name,$lastname,$street1,$city,$state,$zip,$country,$email,
$username,$password);
	$fieldsverbose=array('name','lastname','street1','city','state','zip','country','email',
'username','password');

$error="The following required fields were left blank:<br>";

for($count=0;$count<count($fields);$count++)
{

if ($fields[$count]=="")
  {
    $error .= $fieldsverbose[$count];
    $error .= "<br>";
  }
}

$query="select * from members where (username=\"$username\")";
$Result=mysql_query($query);
if($row=mysql_fetch_array($Result))
{
print("<link rel=\"stylesheet\" href=\"../styleNM.css\" type=\"text/css\"><table><tr><td width='100'></td><td><br><br><br>The username \"$username\" is already taken.<br><a href=\"javascript:history.back();\">Click here</a> to go back and choose another.</td></tr></table>");
}

$query="select * from members where (password=\"$password\")";
$Result=mysql_query($query);
if($row=mysql_fetch_array($Result))
{
print("<link rel=\"stylesheet\" href=\"../styleNM.css\" type=\"text/css\"><table><tr><td width='100'></td><td><br><br><br>That password is already taken.<br><a href=\"javascript:history.back();\">Click here</a> to go back and choose another.</td></tr></table>");
}
else
{

if($narrative==1)
{
	$nn=1;
	}
$query="insert into members (name,lastname,street1,street2,city,state,zip,country,email,username,password,narrative,nn,ws) values ('".$name."','".$lastname."','".$street1."','".$street2."','".$city."','".$state."','".$zip."',
'".$country."','".$email."','".$username."','".$password."','".$narrative."','".$nn."','".$ws."')";

if(mysql_query($query))
	setcookie('username', $username, time()+(60*60*24*30), '/', '', 0);
	print("<script language=\"javascript\">
			top.location=\"105/login.php\";
			</script>");
}
}  

[bradgrafelman]

For God's sake (and our sanity's) learn how to use "Enter" to insert line breaks! :eek:

Also, am I blind, or is there no call to mail() in the code snippet you pasted?

Also, "it doesn't work" doesn't tell us what's going on. How do you know? Do you get an error/warning? What is it? What line?

Also, mail() uses the 'sendmail' program on UNIX servers by default. Is your server configured for this? If you are using Windows, did you or your server owner configure the SMTP values correctly to allow mail() to work correctly? If you want to find out more about the current configuration, make a script called phpinfo.php or something similar, that looks like this:

<?PHP
phpinfo();
?>

Post a link for us to check out the config info. But like I said, I couldn't see the mail() function in your code (perhaps because you didn't use the ENTER key!), so I can't debug your call to mail() itself.

EDIT: Thank you for the use of line breaks. Still don't see a mail() anywhere though.