I am setting up another form-->database-->admin email application. i've done this several times before without a glitch.
now I have a problem and I just can't seem to fix it.
The form submits to the database no problem. The email which the submission script generates is where the problem lies. The one field on the table in the html email which gets sent to the site administrator is blank? The data element is a tinytext element and just does not show up in the email. here is the email code from the submission script:
//start building the mail string
$msg = "<html>
<body>
<table width='500' border='1' cellspacing='0' cellpadding='5'>
<tr>
<td width='144'><img src='
http://www.breform.com/BreformWeb_images/logo_75x68_email.gif' width='75' height='68'></td>
<td width='444'><div align='right'><img src='
http://www.breform.com/BreformWeb_images/solidweb_email_ad.gif' width='200' height='55'></div></td>
</tr>
</table>
<table width='500' border='1' cellspacing='0' cellpadding='5'>
<tr>
<td bgcolor='66ffcc'><strong><
font color='#006600' size='3'face='Arial, Helvetica, sans-serif'>Surgeon registration</font></stron
g> </
td>
<td bgcolor='66ffcc'><strong><
font color='#006600' size='3'face='Arial, Helvetica, sans-serif'></font></stron
g> </
td>
</tr>
<tr>
<td bgcolor='#EAEAEA'><font color='#000066' size='2' face='Arial, Helvetica, sans-serif'>Name and Surname:</font> </td>
<td bgcolor='#0000FF'><strong>
<font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'>$_POST[medtitl
e] $_POST[last_name]</font></
strong>&nb
sp;</td>
</tr>
<tr>
<td bgcolor='#EAEAEA'><font color='#000066' size='2' face='Arial, Helvetica, sans-serif'>Office phone number:</font> </td>
<td bgcolor='#0000FF'><strong>
<font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'>$_POST[telnum]
</font></s
trong>&nbs
p;</td>
</tr>
<tr>
<td bgcolor='#EAEAEA'><font color='#000066' size='2' face='Arial, Helvetica, sans-serif'>Cell phone number:</font> </td>
<td bgcolor='#0000FF'><strong>
<font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'>$_POST[cellnum
]</font></
strong>&nb
sp;</td>
</tr>
<tr>
<td bgcolor='#EAEAEA'><font color='#000066' size='2' face='Arial, Helvetica, sans-serif'>Email Address:</font> </td>
<td bgcolor='#0000FF'><strong>
<font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'>$_POST[email_a
ddress]</f
ont></stro
ng> <
/td>
</tr>
<tr>
<td bgcolor='#EAEAEA'><font color='#000066' size='2' face='Arial, Helvetica, sans-serif'>Office fax number:</font> </td>
<td bgcolor='#0000FF'><strong>
<font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'>$_POST[faxnum]
</font></s
trong>&nbs
p;</td>
</tr>
<tr>
<td bgcolor='#EAEAEA'><font color='#000066' size='2' face='Arial, Helvetica, sans-serif'>Consulting Rooms</font> </td>
<td bgcolor='#0000FF'><strong>
<font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'>$_POST[consult
ad]</font>
</strong>&
nbsp;</td>
</tr>
<tr bgcolor='#EAEAEA'>
<td colspan='2'><font size='2' face='Arial, Helvetica, sans-serif'><strong>Commen
ts placed on the breform.com website</strong></font></t
d> </
td>
</tr>
<tr bgcolor='#0000FF'>
<td colspan='2'><strong><font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'>$_POST[comment
s]</font><
/strong>&n
bsp;</td>
</tr>
</table>
</body>
</html>";
It is the consultad data that does not appear in the email for some reason.
How can I fix this? I'm just not seeing the obvious here I think!
Start Free Trial