[Resolved] Spoke to Soon!

[airric]

I have made some progress by putting into an array first

but it don't seem to be working correctly

it mails items but i have to put $item[1] $item[2] $item[3]

and so on it won't automatically increase for variable $item[$i]

clarification: this what ianm trying to accomplish

item1 price1

item2 price2

item3 price3

heres what I have:

$result23 = mysql_query("SELECT title FROM orders where orderid='$orderNumber'",$db);

$i =1;
while ($myrowz = @mysql_fetch_array($result23)){

$titlez[$i]= $myrowz[title];

$i++;

}

$subject = "Order Confirmation;
for ($i=1;$i<=count($titlez[$i]);$i++) {$message .= $titlez[1] . "" . $titlez[2] . "" . $titlez[3] . "" . $titlez[4] . "\n";}
mail($email_address, $subject, $message, "From: <>\nX-Mailer: PHP/" . phpversion());

[TheDefender]

How about trying something a little more along these lines?

<?php
$result23 = mysql_query("SELECT title FROM orders where orderid='$orderNumber'",$db); 

$titlez = Array();
while ($myrowz = @mysql_fetch_array($result23)){ 
	$titlez[]= $myrowz["title"]; 
} 

$subject = "Order Confirmation"; 
$message = implode(", ", $titlez);

mail($email_address, $subject, $message, "From: <>\nX-Mailer: PHP/" . phpversion()); 
?>

[airric]

Very Nice and easy too! Thank you very much.

[TheDefender]

You're welcome. I encourage you to look into the array and string functions in the PHP manual, and seeing how you can apply, manipulate and use them in conjunction with the DB manipulation. They are VERY effective tools for temporarily handling your DB output data. It will make your coding life much easier!

[airric]

Thank you, I will. Right Now! Because I have to figure how to make this work with the rest my email message.

Thanx again, Airric

[TheDefender]

Well, if you need any more help, be sure to ask for it! Someone is always there, ready to jump right in.

[airric]

Will do! and did I mention that I love this site.

[airric]

i Can't seem to figure how add other $vars to the output

I tried adding $vars to the array and adding parameters to the implode() and even add another implode

This only my first implode is outputed!

[TheDefender]

Well, the implode gives you a string output (The array is now gone, once you implode).

So, to append $vars to it, just concatenate them...

$message .= $vars;
// OR
$message = $message.$vars;

[airric]

Thought I tried that. Hmmmmmm maybe not that was along time ago LOL. Thanks

[airric]

is there a way to line break the output. I've been reading on it but, somtimes the PHP manual gives me brain aches. I'll keep at it.