array implode

[Anon]

I have this problem, I am trying to output an array to a mail() function. The problem is how do I output the results according to a loop

Example

**********this is my query*********

$temp_links_query=mssql_query("SELECT*
FROM temp_link_doc
WHERE document_number = '$document_number'
");
while($row_2=mssql_fetch_array($temp_links_query))
{
$link_doc_1=$row_2["link_doc_1"];
$link_doc_2=$row_2["link_doc_2"];
$link_doc_3=$row_2["link_doc_3"];
$link_doc_4=$row_2["link_doc_4"];
$link_doc_5=$row_2["link_doc_5"];
$link_doc_6=$row_2["link_doc_6"];
$link_doc_7=$row_2["link_doc_7"];
$link_doc_8=$row_2["link_doc_8"];
$link_doc_9=$row_2["link_doc_9"];
$link_doc_10=$row_2["link_doc_10"];
$link_doc_11=$row_2["link_doc_11"];
$link_doc_12=$row_2["link_doc_12"];
$link_doc_13=$row_2["link_doc_13"];
$link_doc_14=$row_2["link_doc_14"];
$link_doc_15=$row_2["link_doc_15"];
$link_doc_16=$row_2["link_doc_16"];
$link_doc_17=$row_2["link_doc_17"];
$link_doc_18=$row_2["link_doc_18"];
$link_doc_19=$row_2["link_doc_19"];
$link_doc_20=$row_2["link_doc_20"];
}

///////////The result can be 0 or it can be 1
I only want to show the results that = 1. So i need to find a way that will only implode the variables that = 1 in to a variable such as this $mailstring=implode("<br>", $link_docs_that_equal_1);

So my variable will out put like this

Link_1
Link_2
Link_3
Link_4

I hope this makes sense

[ame12]

Why not do something like this:

while($row_2=mssql_fetch_array($temp_links_query))
{
for ($doc = 1; $doc < 20; $doc++) {
fldname = "link_doc_".$doc;
$link_doc = $row_2[$fldname];
if ($link_doc != 1) {
continue;
}
echo($link_doc."<br>");
}
}

Something like this should do it... but what isn't clear from your message is which field(s) return 0 or 1 and which return the links. Either way, you shouldn't have to write manual code for 20 fields.

Dave

===========================================
http://badblue.com/helpphp.htm
Free small footprint web server for Windows
Get PHP up and running fast: Win95,98,ME,NT

P2P file-sharing, PHP, wireless apps & more

[seidel]

I have a loop that already does this, what I need is a way to create a variable that I can embed in the mail() function. I can not find a way to execute a loop function inside mail(), therefore I need to create a variable that will output vertically like this
$link_docs=

"<br>link_doc_1
<br>link_doc_2
<br>link_doc_3
<br>link_doc_4
<br>link_doc_5
<br>link_doc_6
<br>link_doc_7"
ect....

if you have any idea how to do this that would be cool!!!!!!!!

[ame12]

Okay I think I see what you're asking. Firstly, the default mail text you send is plain text, not HTML, so adding in <BR>'s probably won't do what you would like. Most mail clients will recognize URL's though so you can still feed in links.

So, something like this might do what you want:

$message = "Here are the links:\r\n\r\n";
$message.= implode("\r\n", $link_doc);
$message.= "\r\n";
mail($recipient, $subject, $message);

Is that what you mean?

Note the manual has discussion of mime-types and attachments, which is what you'll likely need for true rich text / html messages. See http://www.php.net/manual/en/function.mail.php (discussion threads) for more info.

Dave

===========================================
http://badblue.com/helpphp.htm
Get PHP up and running fast: Win95,98,ME,NT
Free small footprint web server with built-

in P2P file-sharing, wireless apps and more

[seidel]

my mail()is set to "Content-type: text/html"

I am not sure what r/n/r/n is and how does this script dynamically define a variable that has the exact amout of results from the query with a possibility of 20 results?

************this is a way better explanation for you**********

The problem:
The query returns an array of 20 results.
The results will have a value greater than 0 or less than 1

I take the results of the array create a variable that will loop through the pieces and discard any value that is less than 1.

Then I want to implode the new array (greater than 0)with <br> inbetween the pieces so I can embed in the mail() function so it will cascade vertically

example

**step 1 QUERY 1 get array from table***

// output record set results from link_doc_temp

$find_link_document=mssql_query("SELECT*
							 	 FROM temp_link_doc
							 	 WHERE document_number = '$document_number' 
							 	")

or die ("link_document failed");

while ($row2=mssql_fetch_array($find_link_document))

{

$link_document_1=$row2["link_doc_1"];
$link_document_2=$row2["link_doc_2"];
$link_document_3=$row2["link_doc_3"];
$link_document_4=$row2["link_doc_4"];
$link_document_5=$row2["link_doc_5"];
$link_document_6=$row2["link_doc_6"];
$link_document_7=$row2["link_doc_7"];
$link_document_8=$row2["link_doc_8"];
$link_document_9=$row2["link_doc_9"];
$link_document_10=$row2["link_doc_10"];
$link_document_11=$row2["link_doc_11"];
$link_document_12=$row2["link_doc_12"];
$link_document_13=$row2["link_doc_13"];
$link_document_14=$row2["link_doc_14"];
$link_document_15=$row2["link_doc_15"];
$link_document_16=$row2["link_doc_16"];
$link_document_17=$row2["link_doc_17"];
$link_document_18=$row2["link_doc_18"];
$link_document_19=$row2["link_doc_19"];
$link_document_20=$row2["link_doc_20"];
}

?>

***Step 2**********

find pieces of original array $link_document_1 through $link_document_20
and discard those that are less than 1 and then implode int a string that will insert <br> inbetween each piece

*****step 3**********

Take new $string_variable and embed in mail()

mail("[e-mail]" ,"Add Document Request_level2", "Link doc results: $string_variable" "Content-type: text/html")