chili91 0 Newbie Poster

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