forward to mail

[SoulAssassin]

I have a view customer / calls page, and want to be able to mail it on to someone.
I think I'm on the right path, but the somehow it doesn't parse the values.

if (isset($_POST['mailto']))
{

$to= "$mailto";
$subject= "Web Enquiry";
$message = "Time of Call - $row[incall]\n\n";
$message .= "Customer Information:\n";
$message .= "$row[name]\n";
$message .= "$row[surname]\n";
$message .= "$row[tel]\n";
$message .= "$row[email]\n\n";

$message .= "Tiffendell Information Required:\n";
$message .= "$row[TDevelop]\n";
$message .= "$row[TConf]\n";
$message .= "$row[TResort]\n\n";

$message .= "Snow Information Required:\n";
$message .= "$row[SSkishop]\n";
$message .= "$row[SCorp]\n";
$message .= "$row[SSlope]\n\n";

$message .= "Kids Information:\n";
$message .= "$row[kids5un]\n";
$message .= "$row[kids5t12]\n";
$message .= "$row[adults12up]\n";
$message .= "$row[total]\n";
$message .= "$row[beginners]\n\n";

$message .= "Please get back to this customer URGENTLY.";

mail ($to,$subject,$message);

echo "Mailed";

}
else
{
echo "Could not mail";
}

?>

[TF_TheMoon]

You're checkking if $_POST['mailto'] is set then are referring to an array called $row and a var called $mailto. Are these actually set?

[SoulAssassin]

I didn't want to post my whole page.
Does this look right?

<?php

$self = $SERVER['php_self'];
$qid = $POST['qid'];
$incall = $POST['incall'];
$name = $POST['name'];
$surname = $POST['surname'];
$email = $POST['email'];
$tel = $POST['tel'];
$TDevelop = $POST['TDevelop'];
$TConf = $POST['TConf'];
$TResort = $POST['TResort'];
$SSkishop = $POST['SSkishop'];
$SCorp = $POST['SCorp'];
$SSlope = $POST['SSlope'];
$Ttotal = $POST['Ttotal'];
$SKids = $POST['SKids'];
$kids5un = $POST['kids5un'];
$kids5t12 = $POST['kids5t12'];
$adults12up = $POST['adults12up'];
$total = $POST['total'];
$beginners = $POST['beginners'];
$date = $POST['date'];
$outcall = $POST['outcall'];
$closed = $POST['closed'];
$imediate = $POST['imediate'];
$today = $POST['today'];
$tomorow = $POST['tomorow'];
$mailto = $_POST['mailto'];

$qid = $row['qid'];
$incall = $row['incall'];
$name = $row['name'];
$surname = $row['surname'];
$email = $row['email'];
$tel = $row['tel'];
$TDevelop = $row['TDevelop'];
$TConf = $row['TConf'];
$TResort = $row['TResort'];
$SSkishop = $row['SSkishop'];
$SCorp = $row['SCorp'];
$SSlope = $row['SSlope'];
$Ttotal = $row['Ttotal'];
$SKids = $row['SKids'];
$kids5un = $row['kids5un'];
$kids5t12 = $row['kids5t12'];
$adults12up = $row['adults12up'];
$total = $row['total'];
$beginners = $row['beginners'];
$date = $row['date'];
$outcall = $row['outcall'];
$closed = $row['closed'];
$imediate = $row['imediate'];
$today = $row['today'];
$tomorow = $row['tomorow'];
$mailto = $row['mailto'];

if (isset($_POST['mailto']))
{

$to= "$mailto";
$subject = "Web Enquiry";
$message = "Time of Call - $row[incall]\n\n";
$message .= "Customer Information:\n";
$message .= "$row[name]\n";
$message .= "$row[surname]\n";
$message .= "$row[tel]\n";
$message .= "$row[email]\n\n";

$message .= "Tiffendell Information Required:\n";
$message .= "$row[TDevelop]\n";
$message .= "$row[TConf]\n";
$message .= "$row[TResort]\n\n";

$message .= "Snow Information Required:\n";
$message .= "$row[SSkishop]\n";
$message .= "$row[SCorp]\n";
$message .= "$row[SSlope]\n\n";

$message .= "Kids Information:\n";
$message .= "$row[kids5un]\n";
$message .= "$row[kids5t12]\n";
$message .= "$row[adults12up]\n";
$message .= "$row[total]\n";
$message .= "$row[beginners]\n\n";

$message .= "Please get back to this customer URGENTLY.";

mail ($to,$subject,$message);

echo "Mailed";
echo = "$row[name]\n";
echo = "$row[surname]\n";
echo = "$row[tel]\n";
echo = "$row[email]\n\n";
}
else
{
echo "Could not mail";
}
?>

[Houdini]

Why are you assigning the variables, qid,incall,name,surname,tel,TDevelop,TConf,...mailto to the $POST values and then doing it again with whatever $row is, I assume that is from the database, if the database has returned no values and there were values from a form (the $POST values) you have just overwritten the $_POST values with blank and your file will send blank values or nothing, you need to assign these values to one or ther other. Why do all that extra coding especially if it is not producing the desired result. you might want to echo the $row variables and see what you get, cause something does not look right here.

[SoulAssassin]

I copied the code from the previous form where I do my
select from database page.
I have worked the code a little, and this what the pages looks like:
Remember it gets the values from the previous page called viewcalls.php

viewforw.php

       $self = $_SERVER['php_self'];
				         $_POST['qid'] = $qid; //not sure which way around this should go.
					 $incall = $_POST['incall'];
					 $name = $_POST['name'];
					 $surname = $_POST['surname'];
					 $email = $_POST['email'];
					 $tel = $_POST['tel'];
					 $TDevelop = $_POST['TDevelop'];
					 $TConf = $_POST['TConf'];
					 $TResort = $_POST['TResort'];
					 $SSkishop = $_POST['SSkishop'];
					 $SCorp = $_POST['SCorp'];
					 $SSlope = $_POST['SSlope'];
					 $Ttotal = $_POST['Ttotal'];
				         $SKids = $_POST['SKids'];
					 $kids5un = $_POST['kids5un'];
					 $kids5t12 = $_POST['kids5t12'];
					 $adults12up = $_POST['adults12up'];
					 $total = $_POST['total'];
					 $beginners = $_POST['beginners'];
					 $date = $_POST['date'];
					 $outcall = $_POST['outcall'];
					 $closed = $_POST['closed'];
					 $imediate = $_POST['imediate'];
					 $today = $_POST['today'];
					 $tomorow = $_POST['tomorow'];
					 $mailto = $_POST['mailto'];

if (isset($_POST['mailto']))
{

$to= "$mailto";
$subject = "Web Enquiry";
$message = "Time of Call - $row[incall]\n\n";
$message .= "Customer Information:\n";
$message .= "$row[name]\n";
$message .= "$row[surname]\n";
$message .= "$row[tel]\n";
$message .= "$row[email]\n\n";

$message .= "Tiffendell Information Required:\n";
$message .= "$row[TDevelop]\n";
$message .= "$row[TConf]\n";
$message .= "$row[TResort]\n\n";

$message .= "Snow Information Required:\n";
$message .= "$row[SSkishop]\n";
$message .= "$row[SCorp]\n";
$message .= "$row[SSlope]\n\n";

$message .= "Kids Information:\n";
$message .= "$row[kids5un]\n";
$message .= "$row[kids5t12]\n";
$message .= "$row[adults12up]\n";
$message .= "$row[total]\n";
$message .= "$row[beginners]\n\n";

$message .= "Please get back to this customer URGENTLY.";

mail ($to,$subject,$message);

}
else
{
echo "Could not mail";
}
?>

[Houdini]

$POST['qid'] = $qid; //not sure which way around this should go.

The '=' is an assignment operator and it will set whatever is on the left to the value of what is on the right. If $qid has a value of "" or blank then gues what $POST['qid'] will equal after the above assognment, it will be blank. This is why is asked why you are assigning allthe values to a forms $_POST values and then turning around and reassigning them to another bunch of values.

In the form or somewhere go ahead and assign the values before you even get to this page to the short variables like name, qid, surname, tel... as you are testing this script if necessary test the values to see just what they do have, for instance

$incall = $_POST['incall'];
echo $incall."<br />";
$name = $_POST['name'];
echo $name."<br />";
$surname = $_POST['surname'];
echo $surname."<br />";
$email = $_POST['email'];
echo $email."<br />";
$tel = $_POST['tel'];
echo $tel."<br />";
$TDevelop = $_POST['TDevelop'];
echo $TDevelop."<br />";

Now when testing if you do not see anything echoed then you will see where the problem is if for example you echoed $name= $_POST['name'] and it echos Joe but later you echo $row['name'] and there is nothing there it is because you have overwritten the first value with the new value of nothing. This is why I asked why you were making all these assignments.

[SoulAssassin]

I know, I'm just confusing myself with setting everything twice.
On my previous page is where it went wrong.
That's where I atrted with the $row[] stuff, can 't even remember what the original reason was. I manage to save my data, and retrieve it easy.
But I can get this thing to echo anything when I try to forward it.

I don't expect you to read through all this code, but maybe you can advise by just glancing at it. I will rebuilt the thing, if there's an easier way.
I'm posting both pages:

PAGE1
viewcalls.php

<?php
$conn = mysql_connect( "localhost", "root", "password" );
$sql = mysql_select_db( "snow" );
$rs = mysql_query("Select * from request order by qid DESC");
$rows = mysql_num_rows($rs);
echo ("<tr>");
echo ("<th align=\"center\" width='50%'>There are $rows records.</th>");
echo ("</tr>");
if(mysql_num_rows($rs))
{
while ($row = mysql_fetch_array($rs))
{
$self = $SERVER['php_self'];
$qid = $POST['qid'];
$incall = $POST['incall'];
$name = $POST['name'];
$surname = $POST['surname'];
$email = $POST['email'];
$tel = $POST['tel'];
$TDevelop = $POST['TDevelop'];
$TConf = $POST['TConf'];
$TResort = $POST['TResort'];
$SSkishop = $POST['SSkishop'];
$SCorp = $POST['SCorp'];
$SSlope = $POST['SSlope'];
$Ttotal = $POST['Ttotal'];
$SKids = $POST['SKids'];
$kids5un = $POST['kids5un'];
$kids5t12 = $POST['kids5t12'];
$adults12up = $POST['adults12up'];
$total = $POST['total'];
$beginners = $POST['beginners'];
$date = $POST['date'];
$outcall = $POST['outcall'];
$closed = $POST['closed'];
$imediate = $POST['imediate'];
$today = $POST['today'];
$tomorow = $POST['tomorow'];
$mailto = $_POST['mailto'];

				         $qid = $row['qid'];
					 $incall = $row['incall'];
					 $name = $row['name'];
					 $surname = $row['surname'];
					 $email = $row['email'];
					 $tel = $row['tel'];
					 $TDevelop = $row['TDevelop'];
					 $TConf = $row['TConf'];
					 $TResort = $row['TResort'];
					 $SSkishop = $row['SSkishop'];
					 $SCorp = $row['SCorp'];
					 $SSlope = $row['SSlope'];
					 $Ttotal = $row['Ttotal'];
					 $SKids = $row['SKids'];
					 $kids5un = $row['kids5un'];
					 $kids5t12 = $row['kids5t12'];
					 $adults12up = $row['adults12up'];
					 $total = $row['total'];
					 $beginners = $row['beginners'];
					 $date = $row['date'];
					 $outcall = $row['outcall'];
					 $closed = $row['closed'];
					 $imediate = $row['imediate'];
					 $today = $row['today'];
					 $tomorow = $row['tomorow'];

echo ("<form action=\"callforw.php\" method=\"post\">");
echo ("<table align=\"center\" width='20%' border=1 bgcolor=\"#FFFFFF\">");
echo ("<tr>");
echo ("<th align=\"center\" width='50%'><font size=\"2\">Call ID:</font></th>");
echo ("</tr>");
echo ("<tr>");
echo ("<td align=\"center\">$row[qid]</td>");
echo ("</tr>");
echo ("</table>");
echo ("<table width='100%' border=1 bgcolor=\"#FFFFFF\">");
echo ("<tr>");
echo ("<th>Time of Request:</th>");
echo ("<td>$row[incall]</td>");
echo ("</tr>");

echo ("<tr>");
echo ("<th><font size=\"2\">Name:</font></th>");
echo ("<td>$row[name]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Surname:</font></td>");
echo ("<td>$row[surname]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">E-Mail:</font></th>");
echo ("<td>$row[email]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Contact Number:</font></th>");
echo ("<td>$row[tel]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Date Interested:</font></th>");
echo ("<td>$row[date]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Convenient Callback Time:</font></th>");
echo ("<td>$row[outcall]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Within 10 Min:</font></th>");
echo ("<td>$row[imediate]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Today:</font></th>");
echo ("<td>$row[today]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Tomorrow:</font></th>");
echo ("<td>$row[tomorow]</td>");
echo ("</tr>");
echo ("</table>");
echo ("<table align=\"center\" width='60%' border=1 bgcolor=\"#FFFFFF\">");
echo ("<tr>");
echo ("<th><font size=\"2\">Tiff Development:</font></th>");
echo ("<td>$row[TDevelop]</td>");
echo ("<th><font size=\"2\">Scape Ski Shop:</font></th>");
echo ("<td>$row[SSkishop]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Tiff Conference:</font></th>");
echo ("<td>$row[TConf]</td>");
echo ("<th><font size=\"2\">Scape Corporate:</font></th>");
echo ("<td>$row[SCorp]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Tiff Resort:</font></th>");
echo ("<td>$row[TResort]</td>");
echo ("<th><font size=\"2\">Scape Indoor Slope:</font></th>");
echo ("<td>$row[SSlope]</td>");
echo ("</tr>");

echo ("</table>");

echo ("<table align=\"center\" width='50%' border=1 bgcolor=\"#FFFFFF\">");
echo ("<tr>");
echo ("<th><font size=\"2\">Kids under 5:</font></th>");
echo ("<td>$row[kids5un]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Kids from 5-12:</font></th>");
echo ("<td>$row[kids5t12]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Adults 12+:</font></th>");
echo ("<td>$row[adults12up]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Amount People:</font></th>");
echo ("<td>$row[total]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Beginners:</font></th>");
echo ("<td>$row[beginners]</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th align=\"center\"><input align=\"center\" type=\"textarea\" name=\"forwmail\" value=\"\">Mail To</th>");
echo ("</tr>");
echo ("<tr>");
echo ("<td align=\"center\"><input type=\"submit\" name=\"mailto\" value=\"Forward\"></td>");
echo ("</tr>");
echo ("</table>");

}
}

echo ("<br>");
echo ("</form>");

?>

When I type in the adress I want to mail it to, it's suppose to go to the next page:
callforw.php

the stuff I put on top.
Now, I'm confused, because I changed the values to many times.
Any suggestions, even if I have to start over.

Once again, I don't know what I would have done without this forum.
No manual can explain like human.
Peace

[Houdini]

I have copied your code and will work with it to try and help you sort it out, right now you need to take a break or you will just get flustered, so go do something else and then later come back and look it over again.

[SoulAssassin]

Cool man, I really appreciate your time and sharing the knowledge.
Hope I can help people to as my knowledge grows.

[Houdini]

You might want to make some changes but here is a view of the actual output, with fake entries from the database.
First PHP page with table display and here is the callforw.php page Callforw.php PageHere is the amended and shortened code. Note that I use the BB Code button to enter this code it is the tilde or ~ right after the # and <> symbols in the posting body seen when composing a post. Just select your code with your mouse and click the tilde symbol, it make reading the code much easier.

<?php
$conn = mysql_connect( "localhost", "root", "password" );
$sql = mysql_select_db( "snow" );
$rs = mysql_query("Select * from request order by qid DESC");
$rows = mysql_num_rows($rs);
echo ("<tr>");
echo ("<th align=\"center\" width='50%'>There are $rows records.</th>");
echo ("</tr>");
if(mysql_num_rows($rs))
{
while ($row = mysql_fetch_array($rs,MYSQL_ASSOC))
{

$qid = $row['qid'];
$incall = $row['incall'];
$name = $row['name'];
$surname = $row['surname'];
$email = $row['email'];
$tel = $row['tel'];
$TDevelop = $row['TDevelop'];
$TConf = $row['TConf'];
$TResort = $row['TResort'];
$SSkishop = $row['SSkishop'];
$SCorp = $row['SCorp'];
$SSlope = $row['SSlope'];
$Ttotal = $row['Ttotal'];
$SKids = $row['SKids'];
$kids5un = $row['kids5un'];
$kids5t12 = $row['kids5t12'];
$adults12up = $row['adults12up'];
$total = $row['total'];
$beginners = $row['beginners'];
$date = $row['date'];
$outcall = $row['outcall'];
$closed = $row['closed'];
$imediate = $row['imediate'];
$today = $row['today'];
$tomorow = $row['tomorow'];
	}
}
?>
<form action="callforw.php" method="post">
<table align=center width='20%' border=1 bgcolor="#FFFFFF">
<tr>
<th align="center" width='50%'><font size="2">Call ID:</font></th>
</tr>
<tr>
<td align="center"><?=$qid?></td>
</tr>
</table>
<table width='100%' border=1 bgcolor="#FFFFF">
<tr>
<th>Time of Request:</th>
<td><?= $incall ?></td>
</tr>

<tr>
<th><font size="2">Name:</font></th>
<td><?= $name ?></td>
</tr>
<tr>
<th><font size="2">Surname:</font></td>
<td><?= $surname ?></td>
</tr>
<tr>
<th><font size="2">E-Mail:</font></th>
<td><?= $email ?></td>
</tr>
<tr>
<th><font size="2">Contact Number:</font></th>
<td><?= $tel ?></td>
</tr>
<tr>
<th><font size="2">Date Interested:</font></th>
<td><?= $date ?></td>
</tr>
<tr>
<th><font size="2">Convenient Callback Time:</font></th>
<td><?= $outcall ?></td>
</tr>
<tr>
<th><font size="2">Within 10 Min:</font></th>
<td><?= $imediate ?></td>
</tr>
<tr>
<th><font size="2">Today:</font></th>
<td><?= $today ?></td>
</tr>
<tr>
<th><font size="2">Tomorrow:</font></th>
<td><?= $tomorow ?></td>
</tr>
</table>
<table align="center" width='60%' border=1 bgcolor="#FFFFFF">
<tr>
<th><font size="2">Tiff Development:</font></th>
<td><?= $TDevelop ?></td>
<th><font size="2">Scape Ski Shop:</font></th>
<td><?= $SSkishop ?></td>
</tr>
<tr>
<th><font size="2">Tiff Conference:</font></th>
<td><?= $TConf ?></td>
<th><font size="2">Scape Corporate:</font></th>
<td><?= $SCorp ?></td>
</tr>
<tr>
<th><font size="2">Tiff Resort:</font></th>
<td><?= $TResort ?></td>
<th><font size="2">Scape Indoor Slope:</font></th>
<td><?= $SSlope ?></td>
</tr>
</table>
<table align="center" width='50%' border=1 bgcolor="#FFFFFF">
<tr>
<th><font size="2">Kids under 5:</font></th>
<td><?= $kids5un ?></td>
</tr>
<tr>
<th><font size="2">Kids from 5-12:</font></th>
<td><?= $kids5t12 ?></td>
</tr>
<tr>
<th><font size="2">Adults 12+:</font></th>
<td><?= $adults12up ?></td>
</tr>
<tr>
<th><font size="2">Amount People:</font></th>
<td><?= $total ?></td>
</tr>
<tr>
<th><font size="2">Beginners:</font></th>
<td><?= $beginners ?></td>
</tr>
<tr>
<th align="center"><input align="center" type="textarea" name="forwmail" value="">Mail To</th>
</tr>
<tr>
<td align="center"><input type="submit" name="mailto" value="Forward"></td>
</tr>
</table>
<br>
</form>

I would make some suggestion on your database but for now let's just get the program to act properly. I tried to use the same data fields but not necessarily with the attributes you used originally, for someof them I made Boolean and had a default of 0 several of them should actually be a Boolean but that is for you to decide. Here is how I set up your tables with MySQL.

DROP TABLE IF EXISTS `request`;
CREATE TABLE IF NOT EXISTS `request` (
  `qid` tinyint(5) NOT NULL auto_increment,
  `incall` varchar(20) collate latin1_general_ci NOT NULL,
  `name` varchar(35) collate latin1_general_ci NOT NULL,
  `surname` varchar(40) collate latin1_general_ci NOT NULL,
  `email` varchar(40) collate latin1_general_ci NOT NULL,
  `tel` varchar(15) collate latin1_general_ci NOT NULL,
  `TDevelop` varchar(15) collate latin1_general_ci NOT NULL,
  `SSkishop` varchar(15) collate latin1_general_ci NOT NULL,
  `TConf` varchar(15) collate latin1_general_ci NOT NULL,
  `SCorp` varchar(15) collate latin1_general_ci NOT NULL,
  `TResort` varchar(15) collate latin1_general_ci NOT NULL,
  `SSlope` varchar(15) collate latin1_general_ci NOT NULL,
  `TTotal` smallint(5) NOT NULL,
  `kids5un` varchar(15) collate latin1_general_ci NOT NULL,
  `kids5t12` varchar(15) collate latin1_general_ci NOT NULL,
  `adults12up` varchar(15) collate latin1_general_ci NOT NULL,
  `total` smallint(5) NOT NULL,
  `beginners` varchar(20) collate latin1_general_ci NOT NULL,
  `date` varchar(20) collate latin1_general_ci NOT NULL,
  `outcall` varchar(20) collate latin1_general_ci NOT NULL,
  `imediate` tinyint(1) NOT NULL default '0',
  `today` tinyint(1) NOT NULL default '0',
  `tomorow` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`qid`)
) ENGINE=InnoDB 

[Houdini]

Let us know how it does!

[SoulAssassin]

Yo thanks, that code makes much more sence than my croped up stuff.

I tried it, and it works great, except that it only shows the first entry from the DB.
I thought there would have been a foreach() somewhere. Because every entry needs their own maillto form. That's why the original form was written in php.
How will that work?

and somehow my server didn't like the <td><?= $incall ?></td> format.
I had to remove the = from it.

[khendar]

You should not actually use <? ?> tags (short tags) because the method is deprecated (outdated). You should really use full <?php ?> tags because half the time your server wont support them

As for the rest - all that black table code should be plated inside the while($row=..) loop if you want a form for every record. Mind you I do not quite know how that is going to work.

[SoulAssassin]

that's what I thought.
So my code right on top was on the right tract?

echo ("<form action=\"callforw.php\" method=\"post\">");
echo ("<table align=\"center\" width='20%' border=1 bgcolor=\"#FFFFFF\">");
echo ("<tr>");
echo ("<th align=\"center\" width='50%'><font size=\"2\">Call ID:</font></th>");
echo ("</tr>");
echo ("<tr>");
echo ("<td align=\"center\">$row[qid]</td>");
echo ("</tr>");
echo ("</table>");
.........

[SoulAssassin]

I'm getting SOOOO frustrated, been siting with this challenge now for 2 solid days, and I'm not really winning.
I can't even print any of the values on the 2nd page.
Don't sure if I should start over, and use SESSIONS to catch the details as I select them. Not sure. Any suggestions?

This is now my 1st page which select values from DB:

<?php
$conn = mysql_connect( "localhost", "root", "password" );
$sql = mysql_select_db( "snow" );
$rs = mysql_query("Select * from request order by qid DESC");
$rows = mysql_num_rows($rs);
echo ("<tr>");
echo ("<th align=\"center\" width='50%'>There are $rows records.</th>");
echo ("</tr>");
if(mysql_num_rows($rs))
{
while ($row = mysql_fetch_array($rs,MYSQL_ASSOC))
{

$qid = $row['qid'];
$incall =$row['incall'];
$name = $row['name'];
$surname = $row['surname'];
$email = $row['email'];
$tel = $row['tel'];
$TDevelop =$row['TDevelop'];
$TConf = $row['TConf'];
$TResort = $row['TResort'];
$SSkishop = $row['SSkishop'];
$SCorp = $row['SCorp'];
$SSlope = $row['SSlope'];
$Ttotal = $row['Ttotal'];
$SKids = $row['SKids'];
$kids5un = $row['kids5un'];
$kids5t12 = $row['kids5t12'];
$adults12up = $row['adults12up'];
$total = $row['total'];
$beginners = $row['beginners'];
$date = $row['date'];
$outcall = $row['outcall'];
$closed = $row['closed'];
$imediate = $row['imediate'];
$today = $row['today'];
$tomorow = $row['tomorow'];

echo ("<form action=\"callforw.php\" method=\"post\">");

echo ("<table align=\"center\" width='20%' border=1 bgcolor=\"#FFFFFF\">");

echo ("<tr>");
echo ("<th align=\"center\" width='50%'><font size=\"2\">Call ID:</font></th>");
echo ("</tr>");
echo ("<tr>");
echo ("<td align=\"center\">".$_POST['qid']."</td>");
echo ("</tr>");

echo ("</table>");

echo ("<table width='100%' border=1 bgcolor=\"#FFFFFF\">");

echo ("<tr>");
echo ("<th>Time of Request:</th>");
echo ("<td>$incall</td>");
echo ("</tr>");
echo ("<tr>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Name:</font></th>");
echo ("<td>$name</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Surname:</font></td>");
echo ("<td>$surname</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">E-Mail:</font></th>");
echo ("<td>$email</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Contact Number:</font></th>");
echo ("<td>$tel</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Date Interested:</font></th>");
echo ("<td>$date</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Convenient Callback Time:</font></th>");
echo ("<td>$outcall</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Within 10 Min:</font></th>");
echo ("<td>$imediate</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Today:</font></th>");
echo ("<td>$today</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Tomorrow:</font></th>");
echo ("<td>$tomorow</td>");
echo ("</tr>");

echo ("</table>");

echo ("<table align=\"center\" width='60%' border=1 bgcolor=\"#FFFFFF\">");

echo ("<tr>");
echo ("<th><font size=\"2\">Tiff Development:</font></th>");
echo ("<td>$TDevelop</td>");
echo ("<th><font size=\"2\">Scape Ski Shop:</font></th>");
echo ("<td>$SSkishop</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Tiff Conference:</font></th>");
echo ("<td>$TConf</td>");
echo ("<th><font size=\"2\">Scape Corporate:</font></th>");
echo ("<td>$SCorp</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Tiff Resort:</font></th>");
echo ("<td>$TResort</td>");
echo ("<th><font size=\"2\">Scape Indoor Slope:</font></th>");
echo ("<td>$SSlope</td>");
echo ("</tr>");

echo ("</table>");

echo ("<table align=\"center\" width='50%' border=1 bgcolor=\"#FFFFFF\">");

echo ("<tr>");
echo ("<th><font size=\"2\">Kids under 5:</font></th>");
echo ("<td>$kids5un</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Kids from 5-12:</font></th>");
echo ("<td>$kids5t12</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Adults 12+:</font></th>");
echo ("<td>$adults12up</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Amount People:</font></th>");
echo ("<td>$total</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th><font size=\"2\">Beginners:</font></th>");
echo ("<td>$beginners</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<th align=\"center\"><input align=\"center\" type=\"textarea\" name=\"forwmail\" value=\"\">Mail To</th>");
echo ("</tr>");
echo ("<tr>");
echo ("<td align=\"center\"><input type=\"submit\" name=\"mailto\" value=\"Forward\"></td>");
echo ("</tr>");

echo ("</table>");

echo ("<br>");

}
}

echo ("</form>");

?>

From here it goes to my forwmail.php page, where my mail() function is suppose to send the entry via e-mail to selected address. But like I said, I don't even get my values here, never mind mailing it.

Peace

[Houdini]

First let me say I am not entirely sure just what you want to do but I have an idea and when you present a long list of code PLEASE use the BB Code that allows it to be viewed better. When you post code there are some tools that will allow you to properly display it namely the # sign allows you to highlight your CODE and then right after it from left to right there is <> which allows the proper display of HTML code and last of all there is a little page with a dogear and a tilde or ~ symbol and that one is for PHP code. Try to remove blank lines of code from your post also, it makes long code even longer and less likely to recieve a response and white space is uneccessary, at least in my case.

Here is some small help, this will send the variables to the next page using the $_SESSION array... those variable only live in the database but with this amendment the code will transfer them to another page also included in this post...you can make the logic work from there. This is the new code for you to test and work with. It is possible to recieve a warning using this code but it will work, I use the latest PHP 5 and recieve it, and can work aroound that, it doesn't really matter cause all you are wanting to do is send an E-mail anyway, that part you can deal with on the second page where if you run the program you will see the variables at least the ones I think are in your database since you never said what all it had in any table.

This code will work it might not necessarily do what you want it to do but for all it is worth then here it is, take it for that.

<?php
session_start();
$conn = mysql_connect( "localhost", "root", "" );
$sql = mysql_select_db( "test" );
$rs = mysql_query("Select * from request order by qid DESC");
$rows = mysql_num_rows($rs);
echo ("<tr>");
echo ("<th align=\"center\" width='50%'>There are $rows records.</th>");
echo ("</tr>");
if(mysql_num_rows($rs))
{
$i=0;  

while ($row = mysql_fetch_array($rs,MYSQL_ASSOC))
{

$qid = $row['qid'];
$incall = $row['incall'];
$name = $row['name'];
$surname = $row['surname'];
$email = $row['email'];
$tel = $row['tel'];
$TDevelop = $row['TDevelop'];
$TConf = $row['TConf'];
$TResort = $row['TResort'];
$SSkishop = $row['SSkishop'];
$SCorp = $row['SCorp'];
$SSlope = $row['SSlope'];
$Ttotal = $row['Ttotal'];
$SKids = $row['SKids'];
$kids5un = $row['kids5un'];
$kids5t12 = $row['kids5t12'];
$adults12up = $row['adults12up'];
$total = $row['total'];
$beginners = $row['beginners'];
$date = $row['date'];
$outcall = $row['outcall'];
$closed = $row['closed'];
$imediate = $row['imediate'];
$today = $row['today'];
$tomorow = $row['tomorow'];
	}
 $i++;
}
$_SESSION['qid']=$qid;
$_SESSION['name']=$name;
$_SESSION['surname']=$surname;
$_SESSION['incall']=$incall;
$_SESSION['name']=$name;
$_SESSION['surname']=$surname;
$_SESSION['email']=$email;
$_SESSION['tel']= $tel;
$_SESSION['TDevelop']=$TDevelop;
$_SESSION['TConf']=$Tconf;
$_SESSION['TResort']=$TResort;
$_SESSION['SSkishop']=$SSkishop;
$_SESSION['SCorp']=$SCorp;
$_SESSION['SSlope']=$SSlope;
$_SESSION['Ttotal']=$Ttotal;
$_SESSION['SKids']=$SKids;
$_SESSION['kids5un']=$kids5un;
$_SESSION['kids5t12']=$kids5t12;
$_SESSION['adults12up']=$adults12up;
$_SESSION['total']=$total;
$_SESSION['beginners']=$beginners;
$_SESSION['date']=$date;
$_SESSION['outcall']=$outcall;
$_SESSION['closed']=$closed;
$_SESSION['imediate']=$imediate;
$_SESSION['today']=$today;
$_SESSION['tomorow']=$tomorow; 
?>
<?php $i=0; echo $_SESSION['qid'], $_SESSION['incall'], $_SESSION['email'], $_SESSION['name']
,$_SESSION['surname'];?>
<form action="callforw.php" method="post">
<table align=center width='20%' border=1 bgcolor="#FFFFFF">
<tr>
<th align="center" width='50%'><font size="2">Call ID:</font></th>
</tr>
<tr>
<td align="center"><?=$qid?></td>
</tr>
</table>
<table width='100%' border=1 bgcolor="#FFFFF">
<tr>
<th>Time of Request:</th>
<td><?= $incall ?></td>
</tr>

<tr>
<th><font size="2">Name:</font></th>
<td><?= $name ?></td>
</tr>
<tr>
<th><font size="2">Surname:</font></td>
<td><?= $surname ?></td>
</tr>
<tr>
<th><font size="2">E-Mail:</font></th>
<td><?= $email ?></td>
</tr>
<tr>
<th><font size="2">Contact Number:</font></th>
<td><?= $tel ?></td>
</tr>
<tr>
<th><font size="2">Date Interested:</font></th>
<td><?= $date ?></td>
</tr>
<tr>
<th><font size="2">Convenient Callback Time:</font></th>
<td><?= $outcall ?></td>
</tr>
<tr>
<th><font size="2">Within 10 Min:</font></th>
<td><?= $imediate ?></td>
</tr>
<tr>
<th><font size="2">Today:</font></th>
<td><?= $today ?></td>
</tr>
<tr>
<th><font size="2">Tomorrow:</font></th>
<td><?= $tomorow ?></td>
</tr>
</table>
<table align="center" width='60%' border=1 bgcolor="#FFFFFF">
<tr>
<th><font size="2">Tiff Development:</font></th>
<td><?= $TDevelop ?></td>
<th><font size="2">Scape Ski Shop:</font></th>
<td><?= $SSkishop ?></td>
</tr>
<tr>
<th><font size="2">Tiff Conference:</font></th>
<td><?= $TConf ?></td>
<th><font size="2">Scape Corporate:</font></th>
<td><?= $SCorp ?></td>
</tr>
<tr>
<th><font size="2">Tiff Resort:</font></th>
<td><?= $TResort ?></td>
<th><font size="2">Scape Indoor Slope:</font></th>
<td><?= $SSlope ?></td>
</tr>
</table>
<table align="center" width='50%' border=1 bgcolor="#FFFFFF">
<tr>
<th><font size="2">Kids under 5:</font></th>
<td><?= $kids5un ?></td>
</tr>
<tr>
<th><font size="2">Kids from 5-12:</font></th>
<td><?= $kids5t12 ?></td>
</tr>
<tr>
<th><font size="2">Adults 12+:</font></th>
<td><?= $adults12up ?></td>
</tr>
<tr>
<th><font size="2">Amount People:</font></th>
<td><?= $total ?></td>
</tr>
<tr>
<th><font size="2">Beginners:</font></th>
<td><?= $beginners ?></td>
</tr>
<tr>
<th align="center"><input align="center" type="textarea" name="forwmail" value="">Mail To</th>
</tr>
<tr>
<td align="center"><input type="submit" name="mailto" value="Forward"></td>
</tr>
</table>
<br>
</form>

Then that will send you to this page named callforw.php

<?php
session_start();
echo "<body bgcolor=lightcoral>";


echo "<h2><center>Welcome to the E-mail Forward page!</center></h2>"; 
echo "OK that part works!<br />";
echo "Now all you need to do is code this part! What you are seeing now is $_SESSION variables<br />";
echo "Maybe now you can figure how to do the rest. Here are the variables on the next page the forward email page that is!";
echo "Here is the QID ".$_SESSION['qid']." <br />";
echo "Here is the In call ".$_SESSION['incall']." <br />";
echo "Here is the First name ".$_SESSION['name']." <br />";
echo "Here is the Surname ".$_SESSION['surname']." <br />";
echo "Next is a list of variables from the database!<br />";
echo "Blah blah blah.............";
//set short variables format this and code the rest your self
echo $qid=$_SESSION['qid']."<br>";
echo $incall=$_SESSION['incall']."<br>";
echo $name=$_SESSION['name']."<br>";
echo $surname=$_SESSION['surname']."<br>";
echo $email=$_SESSION['email']."<br>";
echo $tel=$_SESSION['tel']."<br>";
echo $TDevelop=$_SESSION['TDevelop']."<br>";
echo $TConf=$_SESSION['TConf']."<br>";
echo $TResort=$_SESSION['TResort']."<br>";
echo $SSkishop=$_SESSION['SSkishop']."<br>";
echo $SCorp=$_SESSION['SCorp']."<br>";
echo $SSlope=$_SESSION['SSlope']."<br />";
echo $Ttotal=$_SESSION['Ttotal']."<br />";
echo $SKids=$_SESSION['SKids']."<br />";
echo $kids5un=$_SESSION['kids5un']."<br />";
echo $kids5t12=$_SESSION['kids5t12']."<br />";
echo $adults12up=$_SESSION['adults12up']."<br />";
echo $total=$_SESSION['total']."<br />";
echo $beginners=$_SESSION['beginners']."<br />";
echo $date=$_SESSION['date']."<br />";
echo $outcall=$_SESSION['outcall']."<br />";
echo $closed=$_SESSION['closed']."<br />";
echo $imediate=$_SESSION['imediate']."<br />";
echo $today=$_SESSION['today']."<br />";
echo $tomorow=$_SESSION['tomorow']."<br />";
 ?> 

[SoulAssassin]

I appologise for the messy code, and the way I posted it.
Thanks for the tips.

Let me explain what I need it to.
I have a page where people logg their detail for a "Call Back Request". callin.php
Then it notify someone, who views it online, and see who must handle it. viewcalls.php
She then need to mail certain entries to the correct people (callforw.php), hence the reason we sitting here. certain entries needs to be mailed from the viewcalls page.

And thanks for the code. It does what I want, except that it only pulls the first entry from my database. I need them all to display, so I'll have to put the form in php.
I will try that, and with the sessions you created, I'm sure I'll be able to mail the values.

Thanks

[SoulAssassin]

oh yeh
If I put my form in php, how will convert this:
<td align="center"><?=$qid?></td>

Would it look like this:
echo ("<td align\="center\">"$qid"</td>");

[SoulAssassin]

I've managed to put the form in php. and it displays perfectly.
But doesn't matter under which one I type in the e-mail, it always pulls the first entry on the database.
Shouldn't we set the submit name to the qid or something?
how will the second page know which entry I've chosen?

[SoulAssassin]

Ok, I've tried it in any way I could think of so far.
Only thing I think might word, is to put a checkbox next to each entry.
1 textarea to type in mail to e-mail address.
then do a foreach{ mail() }...

Any suggestions?