no sorry not a seperate database table for every order .
I mean each 'row' has a seperate order stored to it in the cart .
Well that fixed er.
I didnt use the echo $message;
because that echoed it out onto my order success page .
i just made the custom mail as variables to be output with the /r/n lines etc for the mail formatting,
then concatenated each line sorta like this :
Code: Select all
$message .= "line one" . "\r\n" ;
$message .= "line two" . "\r\n" ;
$message .= "line three" . "\r\n" ;
that whole block was in a while loop - while the SQL did the query to get all the data from each table row.
then sent it by mail at the end.
i was sorta surprised when it worked the first time through :)
if it aint broke, dont fix it . I think its good