Hi enigma and thanks again for all your help but it just isn't working!
I read through your last piece several times and implemented it to the word but still no joy.
CODE IS AS FOLLOWS:(simplified)
<?php
$sql = "SELECT * FROM ".$TABLES["one"]." WHERE user_id='".$_SESSION["useraccount"]."'";
$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
$data_array = array();
while ($ONE = mysql_fetch_assoc($sql_result)) {
$sql = "SELECT * FROM ".$TABLES["two"]." WHERE id='".$ONE["user_id"]."'";
$sql_resultT = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
$data_array[]=mysql_fetch_assoc($sql_resultT);
} // closing the while loop
?>
<?
if (isset($action)) {
$to = $data_array["email"]; // GET FAILURE IF THIS LINE LEFT IN // WAS PREVIOUSLY $to = $USER["email"]; // NEED EMAIL FROM TABLE TWO
$mailheader = "From: $email\r\n";
$mailheader .= "Reply-To: $email\r\n";
$mailheader .= "Content-type: text/html; charset=iso-8859-1\r\n";
$msg =
"
Dear
";
for($i=0, $j=count($data_array); $i<$j; $i++ ) {
$msg .= $data_array[$i]['name']; //THIS OK
$msg .= $data_array[$i]['ref']; //THIS IS NOT PULLING REF FROM TABLE ONE BUT SHOWING name FROM TABLE TWO
}
mail($to, "subject", $msg, $mailheader) or die ("Failure"); // WON'T WORK WITH THIS LINE IN
mail("me@my-email.co.uk", "email subject", $msg, $mailheader) or die ("Failure");
echo
"<br /><br /><font size=2><strong><center>Thank you!</center><br />
Your form has been sent:</center><br />
";
};
?>
<table><tr>
<td>TITLE 1</td> <td>TITLE 2</td> <td>TITLE 3</td> <td>TITLE 4</td> <td>TITLE 5</td>
</tr>
<form action="page code is on" method="post">
<input type="hidden" name="action" value="0">
<input type="hidden" name="id" value="<?php echo $_REQUEST["id"]; ?>">
// NOTHING BEEN SHOWN ON FORM PAGE
<tr>
<td><?php echo stripslashes($TWO["name"]); ?></td> //NEED NAME FROM TABLE TWO
<td><?php echo stripslashes($ONE["ref"]); ?></td> // NEED REF No FROM TABLE ONE
<td><?php echo stripslashes($ONE["expiry"]); ?></td> // NEED EXPIRY DATE FROM TABLE ONE
<td><?php echo stripslashes($ONE["type"]); ?></td> // NEED TYPE FROM TABLE ONE
<td><?php echo stripslashes($ONE["plan"]); ?></td> // NEED PLAN FROM TABLE ONE
</tr>
</tr>
</table>
<table width="100%"><tr>
<td align="center" valign="top"> <input type="submit" name="Submit" value="Send"></td>
</tr><tr><td></td></tr></table>
</form>
</table>
Just to reiterate:
I have a form (sort of) on a page which is accessed when a user logs into their account.
The form dynamically pulls bits of the users info from 2 tables in the database, Tables ONE and TWO.
Table TWO holds the users info while Table ONE may hold several items for the user.
When the form page is accessed all the users items from Table ONE are dynamically shown on the form with several checkboxes at the side of each item.
The user can tick certain boxes at the side of each item and click the send button.
TRYING TO ACHIEVE...
After form is sent a thank you message appears on same page with details of the items and what checkboxes were ticked.
Email is sent to user with same info of the items and what checkboxes were ticked.
Email is also sent to me with same info of the items and what checkboxes were ticked.
I need to access Table ONE for the items and Table TWO for users name and email address!
I really appreciate your help but trying your method I could only get one, i.e the form, or the other, i.e the email, to work, even then it was only an email that was physically entered i.e me@my-email.com that would work it would not work with the $to email.
please help it's taking over my life!
