Convert html page or database shopping basket to an email

[Richard Pain]

OK - I have a shopping basket with data in a database. Once the person
has successfully completed their order I want to be able to send them
an email with the products ordered roughly in the following format:

Product Price Quantity

prod1 £6.99 1
prod2 £5.99 2
Postage £0.50

Total whatever..I'm
lazy

Formatting would be a little different (just spacing out the prod
table a little more.

Any ideas or links to scripts that do this?. I've been looking for a
while now but have had no luck in finding a solution. I just want to
send a text email (and not html).

The other thing is that on the last page but one, this shopping basket
is displayed. Is there anyway I could capture the html data from that
page, store it in a session variable and then generate the email after
the order has been completed (so sort of like sending a mirror of that
page)? In that case having a HTML formatted email would be ok.
Many thanks,

Richard Pain

[Dominique]

My Solution has always been to create a UDF to which i can send parameters,
which in turn generates the HTML email and sends it.

In your case, you can just query the data in your hopping basket, and have
it spit out the rows containing the data you have below.

Mail me if you want an example of what i'm talking about

Laterz
Dominique
"Richard Pain" <rj*****@hotmai l.com> wrote in message
news:3b******** *************** **@posting.goog le.com...

OK - I have a shopping basket with data in a database. Once the person
has successfully completed their order I want to be able to send them
an email with the products ordered roughly in the following format:

Product Price Quantity

prod1 £6.99 1
prod2 £5.99 2
Postage £0.50

Total whatever..I'm
lazy

Formatting would be a little different (just spacing out the prod
table a little more.

Any ideas or links to scripts that do this?. I've been looking for a
while now but have had no luck in finding a solution. I just want to
send a text email (and not html).

The other thing is that on the last page but one, this shopping basket
is displayed. Is there anyway I could capture the html data from that
page, store it in a session variable and then generate the email after
the order has been completed (so sort of like sending a mirror of that
page)? In that case having a HTML formatted email would be ok.
Many thanks,

Richard Pain

[Richard Pain]

Hmmm - unfortunately I'm using mysql (hosting on linux with chilliasp)

Thanks

Richard

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Roland Hall]

"Richard Pain" wrote in message
news:3b******** *************** **@posting.goog le.com...
: OK - I have a shopping basket with data in a database. Once the person
: has successfully completed their order I want to be able to send them
: an email with the products ordered roughly in the following format:
:
: Product Price Quantity
:
: prod1 £6.99 1
: prod2 £5.99 2
: Postage £0.50
:
: Total whatever..I'm
: lazy
:
: Formatting would be a little different (just spacing out the prod
: table a little more.
:
: Any ideas or links to scripts that do this?. I've been looking for a
: while now but have had no luck in finding a solution. I just want to
: send a text email (and not html).
:
: The other thing is that on the last page but one, this shopping basket
: is displayed. Is there anyway I could capture the html data from that
: page, store it in a session variable and then generate the email after
: the order has been completed (so sort of like sending a mirror of that
: page)? In that case having a HTML formatted email would be ok.

Richard...

How are you sending the email, Sendmail?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

[Richard Pain]

I think it's just 'mail' - the syntax is:

mail($to, $subject, $body);
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!