Can somone tell me what is wrong with my code here?
My e-mail does not mail me the results from the the latest database entry:
//////////////////////////////////////////////////////
// Mail Handler Routine
/////////////////////////////////////////////////////
function mailer($issue,$host,$sql){
$dbase="lims_issues";
mysqlconn($dbase,$sql);
While($row = mysql_fetch_assoc($result)){
$pid = $row["probid"];
$lid = $row["loggerid"];
$ldate = $row["date"];
$pty = $row["priority"];
$ifc = $row["interface"];
$scr = $row["screen"];
$desc = $row["descript"];
}
mail("[EMAIL PROTECTED]","Issue ID: $issue","A New Issue Has Been
Logged! \n\n".
" Issue ID: $pid \n".
" Logged By: $lid \n".
"Remote Host: $host \n".
" Log Date: $ldate \n".
" Priority: $pty \n".
" Interface: $ifc \n".
" Screen: $scr \n".
"Description: $desc \n");
mysql_free_result($result);
}
The E-mail that is sent looks like this:
A New Issue Has Been Logged!
Issue ID:
Logged By:
Remote Host: 20x.2x.xxx.xxx
Log Date:
Priority:
Interface:
Screen:
Description:
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
