will not sent email. but trying....

[billcoker]

Hi everyone.

The script below is used to send login information to the user if the forget thier login.

One Problem... I will not send the email. I now the email portion works because I use it many other places on the site.
The problem I think is they where I have the row definition placed.

$pass= $r["pass"];
$email = $r["email"];
$memberid= $r["memberid"];

I do not think it is able to pull the email address this way. Do I have these in the wrong place? If the script reaches this porton of the code I have:
echo "Email should be sent"; I get this everytime I enter a correct memberid. So I know it is trying to send the email.

...................................................................................................................

<?

$db_name = "xxxx";
$table_name = "xxx";

$connection = @mysql_connect("localhost", "xxxxx", "xxxxxx")
or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");

$sql = "SELECT * FROM $table_name
WHERE memberid = '$memberid'";

$result = mysql_query($sql)
or die ("Can't execute query.");

$num = mysql_numrows($result);

$pass= $r["pass"];
$email = $r["email"];
$memberid= $r["memberid"];

if ($memberid=="")
echo "<font face='Verdana, Arial, Helvetica, sans-serif' size=2>You must enter your Member ID. </font> ";

else

if ($num != 0) {

echo "Email should be sent";

$msg = "Your login is below. Please keep it in a safe place.\n";

$msg .= "Password: $pass\n";
$msg .= "\n";
$msg .= "This is the message. $message\n\n";

$to = "$email";
$subject = "Your login information!";
$mailheaders = "From: phpcodefinder.com <> \n";
$mailheaders .= "Reply-To: $email\n\n";

mail($to, $subject, $msg, $mailheaders);

} else {

echo "<font face='Verdana, Arial, Helvetica, sans-serif' size=2>";
echo "Your Member ID could not be located.</font><br>";

}

?>

[quicknik]

Hi,

don't you think you need something like
"$r=mysql_fetch_array($result)" 😉

bye,
Niko

[billcoker]

That is why I am asking.

I need to use $num = mysql_numrow($result);
to validate that the member name being enterd is valid.

But I still need to grad the email that is associated with the member name if it is valid to send the email?

[quicknik]

hi,

ok once again:
what you want to to is :

if a member id is set
select the asocciated data from
the db and if the query was successfull
send an mail to
the returned email ..right ?

if so do that:

bye,

       Niko

if (!empty($memberid=="")) {
$db_name = "xxxx";
$table_name = "xxx";

$connection = @mysql_connect("localhost", "xxxxx", "xxxxxx") 
or die("Couldn't connect."); 

$db = mysql_select_db($db_name, $connection) 
or die("Couldn't select database."); 

$sql = "SELECT * FROM $table_name WHERE memberid = '$memberid'"; 

$result = mysql_query($sql) or die ("Can't execute query."); 
if ($r=mysql_fetch_array($result)) {
	$pass= $r["pass"]; 
	$email = $r["email"]; 
	$memberid= $r["memberid"];  
	echo "Email should be sent"; 

	$msg = "Your login is below. Please keep it in a safe place.\n"; 

	$msg .= "Password: $pass\n"; 
	$msg .= "\n"; 
	$msg .= "This is the message. $message\n\n"; 

	$to = "$email"; 
	$subject = "Your login information!"; 
	$mailheaders = "From: phpcodefinder.com <> \n"; 
	$mailheaders .= "Reply-To: $email\n\n"; 

	mail($to, $subject, $msg, $mailheaders); 


} else { 


	echo ""; 
	echo "Your Member ID could not be located.<br>"; 
}

} else {
echo "You must enter your Member ID. ";

}

[amcgrath]

You need to put the $reuslt into an array or object (code below uses array). Try the code below....

$db_name = "xxxx";
$table_name = "xxx";

$connection = @mysql_connect("localhost", "xxxxx", "xxxxxx")
or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");

$sql = "SELECT * FROM $table_name
WHERE memberid = '$memberid'";

$result = mysql_query($sql)
or die ("Can't execute query.");

$num = mysql_numrows($result);
$r = mysql_fetch_array($result,MYSQL_ASSOC);

$pass= $r["pass"];
$email = $r["email"];
$memberid= $r["memberid"];

if ($memberid=="") {
echo "You must enter your Member ID. ";

} else {

if ($num != 0) {

echo "Email should be sent";

$msg = "Your login is below. Please keep it in a safe place.\n";

$msg .= "Password: $pass\n";
$msg .= "\n";
$msg .= "This is the message. $message\n\n";

$to = "$email";
$subject = "Your login information!";
$mailheaders = "From: phpcodefinder.com <> \n";
$mailheaders .= "Reply-To: $email\n\n";

mail($to, $subject, $msg, $mailheaders);

} else {

echo "";
echo "Your Member ID could not be located.<br>";

}

}

[amcgrath]

What is phpcodefinder anyway?

[billcoker]

Thanks, I will give it a try. phpcodefinder is a php script repository for php scripts and code only. It will be open as soon as I add the final touches.

One of the major diffrences between this and other code sites is you can edit your script and add more in real time.

PLus lots of other features. If you would like me to email you when we open just send an email to [e-mail] with your email address and I will email you. Probably another week and 1/2 before we open.

I will try this and get back to you.

thanks. Bill.

[billcoker]

Allen,

Thanks it worked great. Still learning as I go glad that I can get a little help along the way.

Thanks,

Bill.

[amcgrath]

you're welcome.

[billcoker]

Thanks I was helped with this already. You were correct in your code.

Thanks,

Bill