need array help

[jrobles]

$qry ="SELECT ProductID, SUM(QtyOrdered) AS Count FROM OrderHeader_1 JOIN  OrderDetail ON OrderHeader_1.OrderID = OrderDetail.OrderID WHERE OrderHeader_1.OrderID = $oid GROUP BY ProductID";
$result = @mysql_query($qry);
$rows = mysql_fetch_array($result);

 

returns:

ProductID      Count

1                    7

3                    2

 

how can I place the array contents in $message

 

so I can email the query results using phpmailer

 

[jskywalker]

<?php
        $a=array('1' => '1', '2' => '2', '3' => '3', '4'=>'4');

        $message="";
        for ($x = 1; $x <= count($a); $x++)
        {
                $message.=$a[$x];
        }
        echo $message;
?>

[premiso]

$message = "ProductID\tCount\n";
while ($rows = mysql_fetch_assoc($result)) {
    $message .= "{$rows['ProductID']}\t{$rows['Count']}\n";
}

 

Should do the trick.

[jrobles]

thanks for your help guys, but its not working quite right.

 

premiso's code returned:

ProductID Count 1 7 3 2

 

jskywalker's code returned:

7

 

 

[wildteen88]

premiso's code does exactly what you're wanting to do. How are you outputting $message variable?

[jrobles]

im using $message as the email body for phpmailer

[premiso]

Are you sending the email as HTML? If so a modification to my code would be:

 

$message = "<table><tr><td>ProductID</td><td>Count</td></tr>";
while ($rows = mysql_fetch_assoc($result)) {
    $message .= "<tr><td>{$rows['ProductID']}</td><td>{$rows['Count']}</td></tr>";
}
$message .= "</table>";

 

Which should send properly as html.