Complex PHP Email

[kpWEB]

I currently use the basic PHP Email function, such as:

mail("[e-mail]","CATALOG REQUESTED","We have received a catalog request! \n \nNAME: $FNAME $LNAME \nADDRESS: $ADDRESS \nCITY: $CITY \nSTATE ZIP: $STATE $ZIP \nEMAIL: $EMAIL \nPHONE: $PHONE","From: Webmaster");

Now, I ned to have a SQL querry to email information from the database, a shopping cart to be exact. Can this be done.

An example of the body follows follows:

An order has been receievd!

Catalog Numberx Quantityx
Catalog Numbery Quantityy
Catalog Numberz Quantityz

etc
etc
etc

[dalecosp]

Originally posted by kpWEB
I currently use the basic PHP Email function, such as:

mail("[e-mail]","CATALOG REQUESTED","We have received a catalog request! \n \nNAME: $FNAME $LNAME \nADDRESS: $ADDRESS \nCITY: $CITY \nSTATE ZIP: $STATE $ZIP \nEMAIL: $EMAIL \nPHONE: $PHONE","From: Webmaster");


Now, I ned to have a SQL querry to email information from the database, a shopping cart to be exact. Can this be done.

An example of the body follows follows:

An order has been receievd!

Catalog Numberx Quantityx
Catalog Numbery Quantityy
Catalog Numberz Quantityz

etc
etc
etc

Check out the prototype for the mail() function. It's something like

mail($to, $subject, $message, [$headers]);

....so, you just do this:

$Message="$num1   $quan1\n";
$Message.="$num2 $quan2\n";
//etc., etc.,
mail="[e-mail]", "order from shopping cart", $Message);

....piece of cake!

[jayc]

I'm a little late to the convo, but I thought I'd share anyway:

http://phpmailer.sourceforge.net/

[kpWEB]

Thank You!