Sending email from results of a Recordset

John Alexander Hopper · #1 Mar 8th, 2008, 22:21

Hi

Following on from my earlier post, I now need to know how to set the variables of my mailer script to the information stored in the recordset.

For example, my recordset is called rsLast, and I want to send a pre-determined welcome/confirmation email to new members...

Here's what I have so far, but it's not working - can someone please spot the problem....

PHP: Select all


<?php
    $mailtoname = "row_rsLast['fname']  row_rsLast['lname']";
    $mailfromname = "Test Server";
    $mailtoaddress = "row_rsLast['email']";
    $mailtocomplete = "row_rsLast['fname'] <$mailtoaddress>";
    mail($mailtocomplete, "Welcome to the Member's Zone!", "Message body goed here");
?>

I tried putting dollar signs in front of the recordset variables but it doesn't like this.

It's probably glaring me in the face but I can't see it!

Thanks in advance

John

alexgeek · #2 Mar 8th, 2008, 22:45

You have to surround them in curly braces with a dollar sign if it's an array, e.g.:

PHP: Select all


    $mailtoaddress = "{$row_rsLast['email']}";

Or if that doesn't work still:

PHP: Select all


    $mailtoaddress = $row_rsLast['email'];

John Alexander Hopper · #3 Mar 8th, 2008, 23:00

Hey Alexgeek

Thanks for that - works great!

John

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP email form not sending email	Kurt	PHP Forum	1	Oct 12th, 2007 04:26
sending email arrays with php	ppgpilot	PHP Forum	2	Jan 25th, 2007 16:49
Email + attachment sending	manzil	PHP Forum	1	Aug 4th, 2006 13:40
Sending Email	Paul00000001	JavaScript Forum	3	Jul 29th, 2006 03:16
Sending email	Paul00000001	PHP Forum	6	Jul 10th, 2006 11:49

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Sending email from results of a Recordset