Problem with retrieving Data with MySQL
| From: | Blaine D. Dinsmore | Date: | Thu, 18 Jul 2002 18:18:07 +0000 |
| Subject: | Problem with retrieving Data with MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20631@lists.php.net to get a copy of this message | ||
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("dinsmoreb@michigan.gov","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: