sending an array in an e-mail

[ejwf]

I want to send an e-mail that contains an array of information - how do I incorporate this into the 'text' of the e-mail

so far I have got

//create the array
$query = "SELECT SId FROM tblS WHERE CoRef = '$CoRef'";
$result21 = mysql_query($query)  	or die (mysql_error());
while($row21 = mysql_fetch_array($result21))
$SRef[] = $row21["SId"]; 

//I have tested the array - all OK
print_r ($SRef);

$body  = "
Hello this is the information you requested
 ' " .$SRef. " '

thanks
";

mail ("[e-mail]","information","$body");

this outputs in the body of the email as


Hello this is the information you requested
'Array'

thanks

How do I output the array in an e-mail?

Can anyone help - thanks

[bpat1434]

$SRef = '';

while($row21 = mysql_fetch_array($result21))
{
$SRef .= $row21["SId"]."\n";
}

[ejwf]

I'm sorry but I don't follow what you are saying.

Tried engaging my brain but nothing really happened !
I changed my code as per your suggestion to

//create the array 
$query = "SELECT SId FROM tblS WHERE CoRef = '$CoRef'"; 
$result21 = mysql_query($query)      or die (mysql_error()); 
while($row21 = mysql_fetch_array($result21)) 
{ 
$SRef .= $row21["SId"]."\n"; 

//I have tested the array - all OK 
print_r ($SRef); 
}

$body  = " 
Hello this is the information you requested 
' " .$SRef. " ' 

thanks 
"; 

mail ("[e-mail]","information","$body");  

But still get the same e-mail output with just the word 'Array' instead of the actual contents of the array..........

Have I got the right idea ? Also, where am I supposed to use
$SRef = '';

thanks

[Sayian]

$body  = ' Hello this is the information you requested' . $SRef;

[ejwf]

Thanks Sayian

Unfortunately this just echos the variable name not the contents of the array.......

Tried it with double quotes instead of the single quote and that goes back to echoing just Array

[Sayian]

Try this

//create the array
$query = "SELECT `SId` FROM `tblS` WHERE `CoRef` = '$CoRef'"; 
$result21 = mysql_query($query)  or die ('Selection Failed because' . mysql_error()); 
while($row21 = mysql_fetch_array($result21)) {
$SRef = $row21['SId'];
}

$body  = " Hello this is the information you requested " . "/n" . $SRef . "/n Thanks";

mail ('[e-mail]','information','$body');  

[ejwf]

Nope, sorry - now it outputs
/nArray/n

I don't know if this has anything to do with it.......... I am trying to output an array not just a single value, so my code is

while($row21 = mysql_fetch_array($result21)) { 
$SRef[] = $row21['SId']; 
} 

not

while($row21 = mysql_fetch_array($result21)) { 
$SRef = $row21['SId']; 
} 

I can get a single value to output with no problem - the issue I have is with the array ......

[khaine]

Try this

//create the array
$query = "SELECT SId FROM tblS WHERE CoRef = '$CoRef'"; 
$result21 = mysql_query($query)      or die (mysql_error()); 
$body="\nHello this is the information you requested\n'";
while($row21 = mysql_fetch_array($result21))
{
    $body.=$row21["SId"]."\n";
}
$body.="'\nthanks\n";

mail ("[e-mail]","information","$body");

[ejwf]

thanks but no this doesn't work either
It doesn't echo anything for the array (not even the word Array) and the subsequent text that follows the array doesn't print out either

[laserlight]

Basically, you want to traverse the array and concatenate its contents with the message to be sent.
In this case, the email message is contained in $body.

//create the array
$query = "SELECT `SId` FROM `tblS` WHERE `CoRef` = '$CoRef'"; 
$result21 = mysql_query($query)  or die ('Selection Failed because' . mysql_error()); 
$body  = " Hello this is the information you requested/n";
while($row21 = mysql_fetch_array($result21)) {
	$body .= $row21['SId'];
}
$body .= "/n Thanks";

mail ('[e-mail]','information','$body');