SEND AN EMAIL WITH DATABASE INFO...

[robertoduran]

Im trying to build an application for a shopping cart that when the user want to place his order the system sends me an email with the order:

I have a table called acuario_shop_temp that have:

===========
id_ses
id_product
cant

date

What i do is do a:

"$info = mysql_query ("Select * from acuario_shop_temp where id_ses = $id_ses"

now.. that returns multiple lines wich i read as:

while ($row = mysql_fetch_row($info)){

}

then i want to use the funtion mail()

so i do the

$send = mail($to, $subject,$message,$mailHead,$mailparam);

HOW.. do i fill that variable $MESSAGE with the rows that i get from the table acuario_shop_temp ???

any ideas?? :eek: :eek:

[Houdini]

First initialize $Message to nothing

$Message="";

then concatenate the $Message in the while loop like

$Message.=//something from the $row[array]

[cgraz]

just like you would anything else. Image your table contains the following rows:

name
address
phone
fax
email

and you used mysql_fetch_object...

$msg = '';
$subject = 'Your Subject Here';
$headers = 'From: [e-mail]';

while( $row = mysql_fetch_object( $info ) )
{
	$to = $row->email;

$msg .= 'Name: ' . $row->name . "\n";
$msg .= 'Address: ' . $row->address . "\n";
$msg .= 'Fax: ' . $row->fax . "\n";
$msg .= 'Email: ' . $row->email . "\n";

mail( $to, $subject, $msg, $headers );
}

[robertoduran]

Perfect.. It worked 😉

thank you so much..

[Houdini]

Great now please mark your post Resolved you can see how in my signature under the How to show your thread Resolved link.