Hi team,
Thanks for the view..
So here is my question...
Here's what I am trying to do... I have a form that people fill in to send an email to selected people. They fill in the form and it now goes to a database to hold it until approved by the admin (me). So I thought that if I could autofill a new form with thier info I would send it for them. But when I tried, the submit button to a separate php was giving errors...
I pieced meal a few codes which I know is messing it up
1 to put a prev and next record link on page
2 was originally for autofilling fields
Here is the code:
<?php
// Connect to server and select database.
session_start();
session_unregister("data");
if(!session_is_registered("data")) {
session_register("data");
$db = mysql_connect("$hostname", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$result = mysql_query("SELECT * from $tbl_name");
while($row = mysql_fetch_array($result)) {
$data[] = $row;
}
}
$offset = ($offset) ? $offset : 0;
?>
<link rel="stylesheet" href="/css/style.css" type="text/css">
<form name="tellanofficial" action="insertbne3.php" method="post" onSubmit="return checkfields()">
<div align="center">
<center>
<table border="0" cellpadding="10" cellspacing="0">
<tr>
<td>
<table border="0" cellSpacing="0" cellPadding="0" width="100%">
<tr>
<td colSpan="2"><span class="xc_labeltext"><strong><font size="2" face>
Your Contact Information:</font></strong></span></td>
</tr>
<tr>
<td>
<style type="text/css">
<!--
.inputtext { width: 354px; height: 144px;
white-space: -moz-pre-wrap !important; /* Mozilla, since 1999 */
white-space: -pre-wrap; /* Opera 4-6 */
white-space: -o-pre-wrap; /* Opera 7 */
white-space: pre-wrap; /* css-3 */
word-wrap: break-word; /* Internet Explorer 5.5+ */
}
table.xform_table td {
padding-bottom: 2px
}
-->
</style>
<table class="xform_table" border="0" cellSpacing="0" cellPadding="0" width="100%">
<tr>
<td style="padding-bottom: 2px"><font face size="2">
<br>
</font><input style="WIDTH: 40px" class="xc_maintext" maxLength="50" size="29" name="prefixprospect" value="<?=$data[$offset]['prefixprospect']?>">
<span id="x_id__prefix" class="xc_datalabel"><font face size="2"><strong><font color="#333333">
Prefix </font></strong>
<span class="xc_maintext"></span></font><span class="xc_maintext"></span><font face size="2"><strong><font color="#333333">
</font></strong>
</font>
</span></td>
</tr>
<tr>
<td style="padding-bottom: 2px">
<table border="0" cellSpacing="0" cellPadding="0">
<tr>
<td style="padding-bottom: 2px">
<span id="x_id__first" class="xc_datalabel"><strong>
<font color="#333333" size="2" face>First </font>
</strong></span><font face size="2" color="#cc0000">
<span class="cwsubredbold">*</span><br>
</font>
<input style="WIDTH: 228px" class="xc_maintext" maxLength="50" size="29" name="firstprospect" AUTOCOMPLETE="On" value="<?=$data[$offset]['firstprospect']?>"></td>
<td style="padding-bottom: 2px">
<font color="#cc0000" size="2" face>
<img border="0" alt="" src="sec_remove_eng.png" width="10" height="1"></font></td>
<td style="padding-bottom: 2px">
<span id="x_id__last" class="xc_datalabel"><strong>
<font color="#333333" size="2" face>Last </font>
</strong></span><font face size="2" color="#cc0000">
<span class="cwsubredbold">*</span><br>
</font>
<input style="WIDTH: 228px" class="xc_maintext" maxLength="50" size="29" name="lastprospect" AUTOCOMPLETE="On" value="<?=$data[$offset]['lastprospect']?>"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding-bottom: 2px">
<span id="x_id__email" class="xc_datalabel"><strong>
<font color="#333333" size="2" face>Email </font></strong>
</span><font face size="2" color="#cc0000">
<span class="cwsubredbold">*</span><br>
</font>
<input style="WIDTH: 468px" class="xc_maintext" maxLength="71" size="60" name="email0" AUTOCOMPLETE="On" value="<?=$data[$offset]['email0']?>"></td>
</tr>
<tr>
<td style="padding-bottom: 2px">
<span id="x_id__address" class="xc_datalabel"><strong>
<font color="#333333" size="2" face>Address </font></strong>
</span><font face size="2" color="#cc0000">
<span class="cwsubredbold">*</span><br>
</font>
<input style="WIDTH: 468px" class="xc_maintext" maxLength="75" size="60" name="addressprospect" AUTOCOMPLETE="On" value="<?=$data[$offset]['addressprospect']?>"></td>
</tr>
<tr>
<td style="padding-bottom: 2px">
<span id="x_id__city" class="xc_datalabel"><strong>
<font color="#333333" size="2" face>City </font></strong></span>
<font face size="2" color="#cc0000"><span class="cwsubredbold">*</span><br>
</font>
<input style="WIDTH: 125px" class="xc_maintext" maxLength="50" size="60" name="cityprospect" AUTOCOMPLETE="On" value="<?=$data[$offset]['cityprospect']?>"></td>
<td style="padding-bottom: 2px">
<table border="0" cellSpacing="0" cellPadding="0">
<tr>
<td style="padding-bottom: 2px"><font size="2">
<span id="x_id__state" class="xc_datalabel"><strong>
<font color="#333333" face>State </font></strong></span>
<font face color="#cc0000"><span class="cwsubredbold">*</span><br>
</font></font>
<input style="WIDTH: 30px" class="xc_maintext" maxLength="50" size="29" name="stateprospect" value="<?=$data[$offset]['stateprospect']?>">
</td>
<td style="padding-bottom: 2px">
<span id="x_id__azip" class="xc_datalabel"><strong>
<font color="#333333">ZIP </font></strong></span>
<span class="cwsubredbold">*</span><br>
<input class="xc_maintext" maxLength="8" size="8" name="azipprospect" AUTOCOMPLETE="On" value="<?=$data[$offset]['azipprospect']?>"></td>
<td style="padding-bottom: 2px"><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p align="left">These are the people that will be receiving this email
to be sent to:</td>
</tr>
<tr>
<td>
<div align="left">email 1 <input name="fmail1" type="text"maxlength="30"size=25" value="<?=$data[$offset]['fmail1']?>"/>
</div></tr>
<tr>
<td>
<div align="left">email 2 <input name="fmail2" type="text"maxlength="30"size=25" value="<?=$data[$offset]['fmail2']?>"/></div></td>
</tr>
<tr>
<td>
<div align="left">email 3
<input name="fmail3" type="text"maxlength="30"size=25" value="<?=$data[$offset]['fmail3']?>"/> </div></td>
</tr>
<tr>
<td>
<div align="left">Email 4 <input name="fmail4" type="text"maxlength="30"size=25" value="<?=$data[$offset]['fmail4']?>"/> </div></td>
</tr>
<tr>
<td>
<p align="center">
The following email will be sent on your behalf and you may change the message
to be more personalized if you wish. Your sender information will be added
to the top of the email.<p align="center">
<textarea rows="12" name="prospectmessage" cols="84">
<?=$data[$offset]['prospectmessage']?>
</textarea>
<p align="center"><br>
<input onClick="validate();" type="button" value="Click once to send">
<input type=hidden name=refurl value="<? print $refurl;?>">
</td>
</tr>
</table>
</center>
</div>
</form>
<?
if($offset > 0) {
?>
<a href="<?=$PHP_SELF?>?offset=<?=($offset - 1)?>">prev record</a>
<?
}
if($offset < count($data)) {
?>
<a href="<?=$PHP_SELF?>?offset=<?=($offset + 1)?>">next record</a>
<?
}
?>I would appreciate any help I could get..
Thanks...