email db results

viveleroi0

I have a shopping cart that lists items in someones cart using their phpsessid, and in the db there is a seperate listing for each product they have selected. How can I have the query, and then the while loop list the product results out, so that I can put them inside a php email.
I have a $message variable that I want to put the results into, but I cant find a way to do that.

jburfield

Just pull the info from the db and add it to the variable:

$query = "select XXX from TABLE where XXX=XXX";

$result = mysql_query($query, $db_connection);

$message = "xxxxx";
$message .= "\n\n";

while($row = mysql_fetch_row($result))
{
$message .= $row[0] . "\n";
}

mail($to, $subject, $message, $header);

That will take each row from the database and put it on a new line in the $message variable.

bastien

//assume you can get db data out

$message="<html><body><table>";
while ($rows=mysql_fetch_array($result)){
$item=$rows['item'];
$price=$rows['price'];
$quant=$rows['quant'];

 $itemtotal=$quant*$price;
 $nettotal=+$itemtotal;
 //build up the message
$message=."<tr><td>$item</td><td>$quant</td>
                      <td>$price</td><td>$itemtotal</td></tr>";

}
 $message=."<td colspan=3>Total</td><td>
                      $nettotal</td></tr></table>";

 //add more to message here as you require

hth

viveleroi0

I get a parse error on the line with the $message=."whatever";

what is that period supposed to do?

viveleroi0

The period was just on the wrong side. What exactly is it supposed to be used for though? Appending to a previous variable?

bastien

sorry bout that...it is the concatenation symbol