Here is the code for displaying the success approval date which
retrieved from database:-
[code=php]<?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:-
[code=php]$mailbody = $mailbody . “Success date :”.$_POST[‘date’].”n”;
i have tried with hidden input to get the value to be displayed, but failed to do so.
what about array? anyone can assist me on this?
thank you so much.