Jump to content

[SOLVED] can't display topic title in email


kat32

Recommended Posts

<?php
include('config.php');
$query = mysql_query("SELECT topics.topictitle, users.email FROM topics LEFT JOIN users ON topics.userid=users.userid WHERE topics.topicid=1") or die(mysql_error());
$row = mysql_fetch_array($query);
$Name = "kat"; //senders name
$sender_email = "[email protected]"; //senders e-mail adress 
$topictitle=$row['topictitle'];
$email=$row['email'];
$header = "From: ". $Name . " <" . $sender_email . ">\r\n"; 
$subject = "this is the subject";

$qry = mysql_query("SELECT emailmsg FROM emails WHERE emailmsgid=1") or die(mysql_error());
$row = mysql_fetch_array($qry);
$emailmsg=$row['emailmsg'];
$body=$emailmsg;
$sent = mail($email, $subject, $body, $header);	
if($sent){
echo 'sent';
}
?>

 

here's the body of email

 

This is the $topictitle, more text here.

I want to display the topic title after "This is the".

The problem is I can't display the topictitle, please help me. thanks in advance.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.