mail function

searls03 · April 6, 2011

ok addition working, but title1-8 still won't show if !empty

searls03 · April 6, 2011

here the code.......also how do I put in the background image?:

<body><div id='apDiv1'>
  <table width='408' border='1' cellspacing='2' cellpadding='2'>
    <tr>
      <th width='90' scope='col'>Event(s):</th>
      <th width='298' scope='col'>";
  ?>
      <?php
    
$sql = ("SELECT * FROM Events WHERE eventid='$eventid'");
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$event = $row['event'];
$startdate = $row['startdate'];
$enddate = $row['enddate'];
$description = $row['description'];
$location = $row['location'];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];


if (!empty($title1)) { $message .= '<br/>$title1:'; }
if (!empty($title2)) { $message .= '<br/>$title2:' ; }
if (!empty($title3)) { $message .= '<br/>$title3:'; }
if (!empty($title4)) { $message .= '<br/>$title4:'; }
if (!empty($title5)) { $message .= '<br/>$title5:'; }
if (!empty($title6)) { $message .= '<br/>$title6:'; }
if (!empty($title7)) { $message .= '<br/>$title7:'; }
if (!empty($title8)) { $message .= '<br/>$title8:'; }
}
?>

dreamwest · April 7, 2011

Attachments http://www.wizecho.com/nav=php&s=email

searls03 · April 7, 2011

How could I set this as a background image for the emails?

searls03 · April 7, 2011

ok, I can get it to display the events........only it keeps repeating them..........how do I stop it:

$sql = ("SELECT * FROM Events WHERE eventid='$eventid'");
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$event = $row['event'];
$startdate = $row['startdate'];
$enddate = $row['enddate'];
$description = $row['description'];
$location = $row['location'];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];


if (!empty($title1)) { $message .= "<br/>$title1"; }
if (!empty($title2)) { $message .= "<br/>$title2" ; }
if (!empty($title3)) { $message .= "<br/>$title3"; }
if (!empty($title4)) { $message .= "<br/>$title4"; }
if (!empty($title5)) { $message .= "<br/>$title5"; }
if (!empty($title6)) { $message .= "<br/>$title6"; }
if (!empty($title7)) { $message .= "<br/>$title7"; }
if (!empty($title8)) { $message .= "<br/>$title8"; }
}

dreamwest · April 7, 2011

SELECT * FROM Events WHERE eventid='$eventid' LIMIT 1

searls03 · April 7, 2011

i got it working......I had the loop ending wrongly

searls03 · April 7, 2011

so any help on the background issue?:

with this code it works on my ipod but not gmail? is this a browser specific or something

$mailimg = '
<img src="http://final.net46.net/button/boyscout.jpg"</a>
';
	$message = "<html>
	<style type='text/css'>
#apDiv1 {
position:absolute;
left:338px;
top:278px;
width:311px;
height:129px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:50px;
top:207px;
width:181px;
height:149px;
z-index:2;
}
#apDiv2 {
text-align: center;
}
body {
background-image: url(final.net46.net/button/boyscout.jpg);
background-repeat: no-repeat;
}
</style>
</head>

<body><div id='apDiv1'>

  <table width='408' border='1' cellspacing='2' cellpadding='2'>
    <tr>
      <th width='90' scope='col'>Event(s):</th>
      <th width='298' scope='col'>";      
    
$sql = ("SELECT * FROM Events WHERE eventid='$eventid'");
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$event = $row['event'];
$startdate = $row['startdate'];
$enddate = $row['enddate'];
$description = $row['description'];
$location = $row['location'];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];
}

if (!empty($title1)) { $message .= "<br/>$title1"; }
if (!empty($title2)) { $message .= "<hr><br/>$title2" ; }
if (!empty($title3)) { $message .= "<hr><br/>$title3"; }
if (!empty($title4)) { $message .= "<hr><br/>$title4"; }
if (!empty($title5)) { $message .= "<hr><br/>$title5"; }
if (!empty($title6)) { $message .= "<hr> <br/>$title6"; }
if (!empty($title7)) { $message .= "<hr><br/>$title7"; }
if (!empty($title8)) { $message .= "<hr><br/>$title8"; }



  
?>
<?php
$message .="
</th>
    </tr>
    <tr>
      <th>Price:</th>
      <th>
      $ $total

</th>
    </tr>";
?>
<?php
$message .="
    <tr>
      <th>Registrant:</th>
      <th>  $name </th>
    </tr>
  </table>";
  ?>
  <?php
$message .="
</div>
<div id='apDiv2'>$name
  <p> </p>
  <p> </p>
  <p><a href='final.net46.net' target='_new'><strong>Troop 78 Home</strong></a></p>
  <p> </p>
  <p> </p>
  <p><strong><a href='http://www.cornhuskercouncil.org'>Cornhusker Council</a></strong></p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
</div>

	</body>
	</html>";
	// end of message
	$headers = "From: $from\r\n";
	$headers .= "Content-Type: text/html\r\n";
	$to = "$to";
	$message .= $mailimg . $message;
	// Finally send the activation email to the member
	mail($to, $subject, $message, $headers);

searls03 · April 7, 2011

oh and it is displaying the table twice.

Sign In

mail function

Recommended Posts

searls03

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

dreamwest

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

dreamwest

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information