Here is the code for displaying the success approval date which
retrieved from database:-
<?php
if(isset($_POST['find']))
{
$dateid = $_POST['find'];
$sql = "SELECT * FROM application as app
INNER JOIN success_app as appdate
ON app.app_id = appdate.app_id
WHERE app.app_id = '$appid' AND app.date_id = '$dateid'";
$result = mysql_query($sql);
echo "accept date:"."<br/>";
while($accept = mysql_fetch_assoc($result))
{
echo $accept['success_date'];
}
}
?>
**how can i get the $accept['success_date']; to be displayed in my php mailer body if my code
is as below:-
**
$mailbody = $mailbody . "Success date :".$_POST['date']."\n";
anyone can assist on this?? thank you very much