email function help

[paran0id_Dan]

can anyone help with this problem.....I am trying to display my sql results into the message field of an email......for eg

$sql = "

SELECT
(Call.Call_Num) AS 'Call Number',
(Call.AssignTo) AS 'Assigned To',
(Call.OpenDate) AS 'Opened On',
(Call.Summary) AS 'Summary',
ISNULL(Event.Memo, '') AS 'Last Update',
(Event.ChangeDate) AS 'Last Updated On'

FROM Call

LEFT JOIN Event ON Call.Call_ID = Event.Call_ID

WHERE
Call.Status = 'OPEN'
AND
Call.Priority = '1'
AND
Event.ChangeDate = (select max(ChangeDate) from Event as tmp where tmp.call_id = call.call_id)

ORDER BY Call.Call_Num DESC , Event.ChangeDate DESC;

  ";

$rs=odbc_exec($db, $sql);
odbc_result_all($rs);

$to = "[e-mail]";
$subject = "Priority 1 Incidents";
$message = "";
$from = "Customer Support Interface";
$headers = "From: $from";
mail($to,$subject,$message,$headers);
echo "Mail Sent.";

I've tried using $rs but no joy................😕

[NogDog]

For odbc_result_all() I believe you'd need to use output buffering:

ob_start();
odbc_result_all();
$message = ob_get_clean();

[paran0id_Dan]

thanks for help but now I get

Confirmed correct circuit ref: IT1B0000056.</td><td>2008-10-18 09:23:46.000</td></tr>
<tr><td>SMYB94</td><td>LYNESSG</td><td>2008-10-02 21:12:10.000</td><td>Both tills have frozen. Till 1 is frozen mid-transaction. Till 2 is rebooting as we speak.</td><td></td><td>2008-10-06 04:33:37.000</td></tr>
<tr><td>SMYB68</td><td>KAURM</td><td>2008-09-23 07:22:21.000</td><td>With Development..................FATAL ERROR OCCURED THE APPLICATION WILL NOW TERMINATE.</td><td>With Development</td><td>2008-10-04 10:47:49.000</td></tr>
<tr><td>SMYB150</td><td>KAURM</td><td>2008-10-17 14:16:30.000</td><td>Message on till - "please contact PCMS service desk" - also as square at RHS of screen flashing. Only one till at store - </td><td>I have secured logs and have attached these to the call. Have informed Kev C and he will investigate.</td><td>2008-10-17 14:57:56.000</td></tr>
<tr><td>BWG2783</td><td>JONESK</td><td>2008-10-10 09:50:57.000</td><td>Printer in the customer services desk is not printing correctly.

and I need it to return a clean text file

[NogDog]

Then you'll need to loop through the result set yourself, something like:

while(($row = odbc_fetch_array($rs)) != false)
{
   foreach($row as $key => $value)
   {
      echo $key . ': ' . $value . "\n";
   }
   echo "\n";
}

[paran0id_Dan]

I've decided on using this

$rs = odbc_exec($db, $sql);

while (odbc_fetch_row($rs))
{
$callnum=odbc_result($rs,"Call Number");
$assto=odbc_result($rs,"Assigned To");
$openon=odbc_result($rs,"Opened On");
$summary=odbc_result($rs,"Summary");
$memo=odbc_result($rs,"Last Update");
$updateon=odbc_result($rs,"Last Updated On");

echo "<tr><td>$callnum<br></td>";
echo "<tr><td>$assto<br></td>";
echo "<tr><td>$openon<br></td>";
echo "<tr><td>$summary<br></td>";
echo "<tr><td>$memo<br></td>";
echo "<tr><td>$updateon<br></td>";
}

echo "</table>";

$to = "[e-mail]";
$subject = "Priority 1 Incidents";
$message = "$callnum,$assto,$openon,$summary,$memo,$updateon";
$from = "Customer Support Interface";
$headers = "From: $from";
mail($to,$subject,$message,$headers);
echo "Mail Sent.";

which gives me the info I need, however it only returns the last row in the $message, the sql returns all rows

please help

[NogDog]

You need to build $message as part of the while loop, appending the values to it on each iteration; instead of only setting it to the one set of values after the loop, which are the values from the loop's last iteration.

[paran0id_Dan]

thanks, but can you show me how....