$sql = "SELECT probid,loggerid,DATE_FORMAT(logdate,'%m-%d-%Y') AS date," .
"priority,interface,screen,descript,notes " .
"FROM bugs WHERE probid='$issue'";
"Maureen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> It might help if you send the list an indication of what $sql (the query)
> looks like. The only thing it appears to be returning is what was
initially
> sent to the function.
>
> Maureen
>
>
> "Blaine D. Dinsmore" <[EMAIL PROTECTED]> said:
>
> > 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
> >
>
>
>
> --
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
