Try this:
[snip]
is this what you are looking for?
Hi Dasty
Thanks I customized that and connected it to the database to get some values but I have trouble posting the values in the in this field "dispatch_able" please help me out I want to send it to the database and to another page which sends the mail to the form owner
Here is my code thanks in advance
[PHP]<?php require_once('Connections/con1.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO moneydetails (surname, othername, email, passport, `state`, telno, alternativetelno, theDate, banks, `Transaction Id`, amount_banked, balance) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['surname'], "text"),
GetSQLValueString($_POST['othernames'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['passport_no'], "text"),
GetSQLValueString($_POST['states'], "text"),
GetSQLValueString($_POST['telno'], "text"),
GetSQLValueString($_POST['alternativetelno'], "text"),
GetSQLValueString($_POST['theDate'], "text"),
GetSQLValueString($_POST['banks'], "text"),
GetSQLValueString($_POST['bank_transaction_no'], "text"),
GetSQLValueString($_POST['amount_banked'], "text"),
GetSQLValueString($_POST['dispatch_able'], "text"));
mysql_select_db($database_con1, $con1);
$Result1 = mysql_query($insertSQL, $con1) or die(mysql_error());
}
?>
<?php require_once('Connections/con1.php'); ?>
<?php
mysql_select_db($database_con1, $con1);
$query_STATES = "SELECT * FROM countries ORDER BY `state` DESC";
$STATES = mysql_query($query_STATES, $con1) or die(mysql_error());
$row_STATES = mysql_fetch_assoc($STATES);
$totalRows_STATES = mysql_num_rows($STATES);
mysql_select_db($database_con1, $con1);
$query_monet = "SELECT * FROM money";
$monet = mysql_query($query_monet, $con1) or die(mysql_error());
$row_monet = mysql_fetch_assoc($monet);
$totalRows_monet = mysql_num_rows($monet);
?>[/PHP][HTML]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script src="calendar.js"></script>
<title>CARIBBEAN OVERSEAS SERVICES</title>
<style type="text/css">
<!--[/HTML]
- body {
-
margin-left: 100px;
-
margin-right: 100px;
-
background-image: url(images/background.jpg);
-
background-repeat: repeat-x;
-
background-color: #FFFFFF;
-
}
-
back {
-
background-attachment: fixed;
-
background-image: url(images/lineback.jpg);
-
background-repeat: repeat-x;
-
}
-
back {
-
background-attachment: fixed;
-
background-image: url(images/lineback.jpg);
-
background-repeat: repeat-x;
-
}
-
back {
-
background-image: url(images/lineback.jpg);
-
background-repeat: repeat-x;
-
}
-
.back {
-
background-image: url(images/lineback.jpg);
-
background-repeat: repeat-x;
-
}
-
.style3 {
-
color: #D70000;
-
font-weight: bold;
-
text-transform: none;
-
font-size: 13px;
-
font-style: normal;
-
}
-
top {
-
background-image: url(images/top.jpg);
-
background-repeat: no-repeat;
-
}
-
.top {
-
background-image: url(images/top.jpg);
-
background-repeat: no-repeat;
-
}
-
a:link {
-
text-decoration: none;
-
color: #ffffff;
-
}
-
a:visited {
-
text-decoration: none;
-
color: #FFFFFF;
-
}
-
a:hover {
-
text-decoration: none;
-
color: #DF8D10;
-
}
-
a:active {
-
text-decoration: none;
-
}
-
td.off {
-
background: #003366;
-
}
-
-
td.on {
-
background: #003366;
-
}
-
a {
-
font-weight: bold;
-
}
-
.links { font-family: Verdana;
-
font-size: 13px;
-
font-style: normal;
-
font-weight: bold;
-
font-variant: normal;
-
color: #004200;
-
}
-
body,td,th {
-
font-family: Verdana, Arial, Helvetica, sans-serif;
-
font-size: 10px;
-
color: #000000;
-
}
-
.style5 {
-
color: #FFFFFF;
-
font-size: 13px;
-
font-weight: bold;
-
}
-
.style9 {color: #FFFFFF; font-size: 13px; }
-
marquee {
-
font-family: Verdana, Arial, Helvetica, sans-serif;
-
font-size: 9px;
-
font-style: normal;
-
font-weight: bold;
-
font-variant: small-caps;
-
color: #FFFFFF;
-
}
-
.style10 { color: #004200;
-
font-family: Verdana, Arial, Helvetica, sans-serif;
-
font-size: 9px;
-
font-style: normal;
-
line-height: normal;
-
font-weight: normal;
-
font-variant: normal;
-
text-transform: capitalize;
-
}
-
.invisible {
-
background-attachment: fixed;
-
background-repeat: no-repeat;
-
visibility: hidden;
-
font-family: Verdana, Arial, Helvetica, sans-serif;
-
font-size: 8px;
-
}
-
.style11 {color: #004200; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9px; font-style: normal; line-height: normal; font-weight: bold; font-variant: normal; text-transform: capitalize; }
-
buttons {
-
}
-
buton {
-
font-family: Arial;
-
font-size: 8px;
-
}
-
invisible {
-
font-family: Arial;
-
font-size: 9px;
-
visibility: hidden;
-
}
-
[HTML]-->
</style>
<script language="javascript">
[/HTML]
- function val1_change()
-
-
{
-
-
var obj1, obj2, obj3, obj4;
-
-
obj1 = document.getElementById('val1');
-
obj2 = document.getElementById('val2');
-
-
obj3 = document.getElementById('val3');
-
obj4 = document.getElementById('val4');
-
if ((obj1) && (obj2) && (obj3) && (obj4))
-
-
{
-
if (isNaN(obj2.value) || isNaN(obj1.value))
-
{
-
-
obj3.value = '';
-
-
}
-
-
else
-
-
{
-
-
obj3.value = obj1.value * obj2.value;
-
-
}
-
-
{
-
-
obj4.value = obj1.value - obj3.value;
-
-
}
-
-
}
-
-
}
-
-
[HTML] </script>
<link type="text/css" rel="stylesheet" href="dhtmlgoodies_calendar/dhtmlgoodies_calendar.css?random=20051112" media="screen"></LINK>
<SCRIPT type="text/javascript" src="dhtmlgoodies_calendar/dhtmlgoodies_calendar.js?random=20060118"></script>
</head>
<body onload="val1_change();">
<table width="798" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" class="back">
<!--DWLayoutDefaultTable-->
<tr>
<td height="30" colspan="2" valign="bottom" class="style3"><div align="center">swift</div></td>
<td colspan="3" valign="bottom" class="style3"><div align="center">reliable</div></td>
<td width="234" valign="bottom" class="style3"><div align="center">safe</div></td>
</tr>
<tr>
<td height="3" colspan="6" valign="top"><img src="images/line3.gif" width="800" height="3" /></td>
</tr>
<tr>
<td height="154" colspan="3" valign="middle"><div align="center"><img src="images/name.jpg" width="279" height="80" /></div></td>
<td width="15"> </td>
<td width="249" valign="top"><img src="images/boston.jpg" width="234" height="154" /></td>
<td valign="top"><div align="center"><img src="images/nairobic.jpg" width="234" height="154" /></div></td>
</tr>
<tr>
<td height="3" colspan="6" valign="top"><img src="images/line3.gif" width="800" height="3" /></td>
</tr>
<tr>
<td height="13" colspan="6" valign="top"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="800" height="45">
<param name="movie" value="flash/movie.swf" />
<param name="quality" value="high" />
<embed src="flash/movie.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="800" height="45"></embed>
</object></td>
</tr>
<tr>
<td width="222" height="141" valign="top"><table width="201" height="95" border="0">
<tr>
<td width="200" height="20" valign="top" class="off" onmouseover ="this.className='on'" onmouseout ="this.className='off'"><div align="left"><a href="index.php"> <span class="links"> <span class="style5"> home</span></span></a></div></td>
</tr>
<tr>
<td height="21" valign="top" class="off" onmouseover ="this.className='on'" onmouseout ="this.className='off'"><span class="links"> <a href="moneytransfer.html" class="links"> </a></span><span class="style9"><a href="moneytransfer.php" class="style5">money transfer</a></span></td>
</tr>
<tr>
<td valign="top" class="off" onmouseover ="this.className='on'" onmouseout ="this.className='off'"><a href="contactus.php"> <span class="style5"> <span class="style9"> </span>contact us</span></a> </td>
</tr>
<tr>
<td height="22" valign="top" class="off" onmouseover ="this.className='on'" onmouseout ="this.className='off'"><span class="links"> <a href="terms and condations.html" class="style5">terms and condations</a></span></td>
</tr>
</table></td>
<td colspan="4" rowspan="2" valign="top"><table width="342" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="404" valign="top"><form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>">
<table width="335" height="427" border="0">
<!--DWLayoutTable-->
<tr>
<td height="18" colspan="2" class="style11">Your Details </td>
<td colspan="5"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">Surname</div></td>
<td colspan="5" valign="top"><input name="surname" type="text" class="style10" id="surname" size="25" />
*</td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">Other names</div></td>
<td colspan="5" valign="top"><input name="othernames" type="text" class="style10" id="othernames" size="25" />
*</td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">Email</div></td>
<td colspan="5" valign="top"><input name="email" type="text" class="style10" id="email" size="25" />
*</td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">Passport No </div></td>
<td colspan="5" valign="top"><input name="passport_no" type="text" class="style10" id="passport_no" size="25" />
*</td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">Money Transfer code </div></td>
<td colspan="5" valign="top" class="style10"><input name="MT_code" type="text" class="style10" id="MT_code" />
*</td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">State</div></td>
<td colspan="5" valign="top"><span class="style10">
<select name="states" class="style10" id="states" title="<?php echo $row_STATES['state']; ?>">[/HTML]
[PHP] <?php
do {
?>
<option value="<?php echo $row_STATES['state']?>"<?php if (!(strcmp($row_STATES['state'], $row_STATES['state']))) {echo "selected=\"selected\"";} ?>><?php echo $row_STATES['state']?></option>
<?php
} while ($row_STATES = mysql_fetch_assoc($STATES));
$rows = mysql_num_rows($STATES);
if($rows > 0) {
mysql_data_seek($STATES, 0);
$row_STATES = mysql_fetch_assoc($STATES);
}
?>
[/PHP][HTML] </select>
</span> *</td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">Telephone nunber </div></td>
<td colspan="5" valign="top"><input name="telno" type="text" class="style10" id="telno" />
*</td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10"><div align="left">Alternative tel </div></td>
<td colspan="5" valign="top"><input name="alternativetelno" type="text" class="style10" id="alternativetelno" />
*</td>
</tr>
<tr>
<td height="14" colspan="2" valign="top" class="style11">Bank Details </td>
<td colspan="5"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10">date of banking </td>
<td colspan="5" valign="top"><input name="theDate" type="text" class="style10" value="02/11/2007" readonly="readonly" />
<input name="button" type="button" class="style10" onclick="displayCalendar(document.forms[0].theDate,'dd/mm/yyyy',this)" value="select" /></td>
</tr>
<tr>
<td height="20" colspan="2" valign="top" class="style10">Bank</td>
<td colspan="5" valign="top"><span class="style10">
<select name="banks" class="style10" id="banks">
<option value="chase bank">chase bank</option>
<option value="wells fargo">wells fargo</option>
</select>
*</span></td>
</tr>
<tr>
<td height="22" valign="middle" class="style10">Transaction ID </td>
<td> </td>
<td colspan="5" valign="middle"><input name="bank_transaction_no" type="text" class="style10" id="bank_transaction_no" /></td>
</tr>
<tr>
<td width="106" height="22" valign="middle" class="style10">Amount Banked </td>
<td width="12"> </td>
<td width="81" valign="middle"><input name="amount_banked" type="text" class="style10" id="val1" onkeyup="val1_change();" size="15" /></td>
<td width="20" valign="middle"><input name="radiobutton" type="radio" class="on" value="radiobutton" /></td>
<td width="28" valign="middle">US$</td>
<td width="20" valign="middle"><input name="radiobutton" type="radio" class="on" value="radiobutton" /></td>
<td width="38" valign="middle">Euro</td>
</tr>
<?php
$rates= 100-$row_monet['charges'];
$charges=$rates/100;
?>
<tr>
<td height="20" colspan="2" valign="top" class="style10">Charges</td>
<td colspan="5" valign="top"><input name="charges" type="text" disabled="disabled" class="style10" id="val4" value="2%" />
<input name="charges1" type="text" disabled="disabled" class="invisible" id="val2" value="<?php echo $charges; ?>" size="15" /></td>
</tr>
<tr>
<td height="26" colspan="2" valign="top" class="style10">Balance available to send </td>
<td colspan="5" valign="top"><input name="dispatch_able" id="val3" type="text" class="style10" disabled="disabled" /></td>
</tr>
<tr>
<td height="22" colspan="2" valign="top"><input name="Continue" type="submit" class="style10" id="Continue" value="continue" /></td>
<td colspan="5" valign="top"><input name="Continue2" type="reset" class="style10" id="Continue2" value="reset" /></td>
</tr>
<tr>
<td height="26" colspan="7" valign="top" class="style10">Kindly provide details of the beneficiaries’ in this next step.</td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form> </td>
</tr>
</table></td>
<td><!--DWLayoutEmptyCell--> </td>
</tr>[/HTML]
[HTML]
<tr>
<td height="213"> </td>
<td></td>
</tr>
<tr>
<td height="12"> </td>
<td width="53"> </td>
<td width="25"> </td>
<td> </td>
<td> </td>
<td></td>
</tr>
</table>
<div id="debug"></div>
</body>
</html>
[/HTML][PHP]<?php
mysql_free_result($STATES);
mysql_free_result($monet);
?>[/PHP]