les dejo el form y el java por si aparece la "mano amiga que salve"
]
Código PHP :
<?php
$bd=mysql_connect("localhost","root","") or die ("no");
mysql_select_db("fcbase");
$opt=$HTTP_GET_VARS["opt"];
if($opt==1)
{
$nombre=$HTTP_GET_VARS["nombre"];
$email=$HTTP_GET_VARS["email"];
$fecha=$HTTP_GET_VARS["fecha"];
$cod_feria=$HTTP_GET_VARS["cod_feria"];
$comuna=$HTTP_GET_VARS["comuna"];
$ubicacion=$HTTP_GET_VARS["ubicacion"];
$nombre_feria=$HTTP_GET_VARS["nombre_feria"];
$pasaje_oficial=$HTTP_GET_VARS["pasaje_oficial"];
$calle_oficial=$HTTP_GET_VARS["calle_oficial"];
$calle_calzada=$HTTP_GET_VARS["calle_calzada"];
$bandejon_oficial=$HTTP_GET_VARS["bandejon_oficial"];
$bandejon_calzada=$HTTP_GET_VARS["bandejon_calzada"];
$plazapque_oficial=$HTTP_GET_VARS["plazapque_oficial"];
$plazapque_calzada=$HTTP_GET_VARS["plazapque_calzada"];
$sql="insert into prospectos (nombre, email, fecha, cod_feria, comuna, ubicacion, nombre_feria, pasaje_oficial, calle_oficial, calle_calzada, bandejon_oficial, bandejon_calzada, plazapque_oficial, plazapque_calzada) values ('".$nombre."','".$email."','".$fecha."','".$cod_feria."','".$comuna."','".$ubicacion."','".$nombre_feria."','".$pasaje_oficial."','".$calle_oficial."','".$calle_calzada."','".$bandejon_oficial."','".$bandejon_calzada."','".$plazapque_oficial."','".$plazapque_calzada."')";
$res=mysql_query($sql,$bd) or die (mysql_error());
}
?>
<html>
<head>
<title>Untitled Document</title>
<link href="css_ferias.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body,td,th {
color: #000000;
}
-->
</style></head>
<script language="javascript">
function verifica()
{
if(f.email.value=="")
{
alert("por favor tu correo");
return;
}
f.opt.value=1;
f.submit();
}
</script>
<script language="javascript">
function sumar_ue()
{
var a, total = 0;
var elements = document.getElementsByName('sumar_ue');
for(a=0; a<elements.length; a++)
{
total += (parseFloat(elements[a].value));
}
document.getElementById("resultado_ue").value = total;
}
</script>
<body>
<div id="form">
<form name="f">
<input type="hidden" name="opt">
<table width="900" border="0">
<tr>
<td colspan="2"><div id="form1">identificador feria </div></td>
<td colspan="2"><div id="form1">identificador catastrador </div></td>
</tr>
<tr>
<td width="195"><div id="form">codigo feria </div></td>
<td width="196"><select name="cod_feria">
<option selected>seleccione</option>
<option>001_CNV_1</option>
<option>002_CNV_2</option>
<option>003_CNV_3</option>
<option>004_CNV_4</option>
<option>005_CNV_5</option>
<option>006_CNV_6</option>
<option>007_CNV_7</option>
<option>008_CNV_8</option>
<option>009_CNV_9</option>
</select></td>
<td width="195"><div id="form">Fecha Catastro </div></td>
<td width="196"><input type="text" name="fecha" size="35"></td>
</tr>
<tr>
<td><div id="form">Comuna</div></td>
<td><select name="comuna">
<option selected>seleccione</option>
<option>SAN BERNARDO</option>
<option>CERRO NAVIA</option>
<option>LO PRADO</option>
<option>QUINTA NORMAL</option>
<option>SANTIAGO</option>
<option>INDEPENDENCIA</option>
<option>RENCA</option>
<option>RECOLETA</option>
<option>CONCHALI</option>
<option>HUECHURABA</option>
<option>QUILICURA</option>
<option>MACUL</option>
<option>PEÑALOLEN</option>
<option>LA REINA</option>
<option>ÑUÑOA</option>
<option>MAIPU</option>
<option>CERRILLOS</option>
<option>ESTACION CENTRAL</option>
<option>PUDAHUEL</option>
<option>LA GRANJA</option>
<option>LA FLORIDA</option>
<option>PEDRO AGUIRRE CERDA</option>
<option>SAN MIGUEL</option>
<option>SAN JOAQUIN</option>
<option>LO ESPEJO</option>
<option>LA CISTERNA</option>
<option>SAN RAMON</option>
<option>LA PINTANA</option>
<option>SAN BERNARDO</option>
<option>EL BOSQUE</option>
<option>PUENTE ALTO</option>
<option>PROVIDENCIA</option>
<option>VITACURA</option>
<option>LAS CONDES</option>
<option>LO BARNECHEA</option>
</select></td>
<td><div id="form">Nombre</div></td>
<td><input type="text" name="nombre" size="35"></td>
</tr>
<tr>
<td><div id="form">Ubicación (dirección formal) </div></td>
<td><input type="text" name="ubicacion" size="35"></td>
<td><div id="form">Email - Telefono </div></td>
<td><input type="text" name="email" size="35"></td>
</tr>
<tr>
<td><div id="form">Nombre feria </div></td>
<td><input type="text" name="nombre_feria" size="35"></td>
<td> </td>
<td> </td>
</tr>
</table>
<br>
<table width="900" border="0">
<tr>
<td width="177"><div id="form" align="center">Pasaje<br>
<img src="img_fcb/1-01.jpg" width="162" height="73"></div></td>
<td width="239"><div id="form" align="center">Calle<br>
<img src="img_fcb/2-01.jpg" width="162" height="73"></div></td>
<td width="243"><div id="form" align="center">Bandejón Central<br>
<img src="img_fcb/3-01.jpg" width="162" height="73"></div></td>
<td width="223"><div id="form" align="center">Plaza Parque<br>
<img src="img_fcb/4-01.jpg" width="162" height="73"></div></td>
</tr>
<tr>
<td><div id="form2" align="center">Oficial (a)
<select name="pasaje_oficial">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
m</div></td>
<td><div id="form2" align="center">Oficial (a)
<select name="calle_oficial">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
m Calzada (b)
<select name="calle_calzada">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
</select>
m</div></td>
<td><div id="form2" align="center">Oficial (a)
<select name="bandejon_oficial">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
m Calzada (b)
<select name="bandejon_calzada">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
</select>
m
</div></td>
<td><div id="form2" align="center">oficial (a)
<select name="plazapque_oficial">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
m Calzada (b)
<select name="plazapque_calzada">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
</div></td>
</tr>
</table><br>
<table width="900" border="0">
<tr>
<td width="187"> </td>
<td width="214"> </td>
<td width="83"> </td>
<td width="54"><div id="form" align="center">Tramo 1 </div></td>
<td width="54"><div id="form" align="center">Tramo 2 </div></td>
<td width="54"><div id="form" align="center">Tramo 3 </div></td>
<td width="54"><div id="form" align="center">Tramo 4 </div></td>
<td width="54"><div id="form" align="center">Tramo 5 </div></td>
<td width="54"><div id="form" align="center">Tramo 6 </div></td>
<td width="50"><div id="form" align="center">Total </div></td>
</tr>
<tr>
<td><div id="form" align="center">Información Comercial</div></td>
<td><div id="form" align="center">Ubicación y extensión</div></td>
<td> </td>
<td><div align="center">
<select name="sumar_ue" onchange="sumar_ue()">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
</div></td>
<td><div align="center">
<select name="sumar_ue" onchange="sumar_ue()">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
</div></td>
<td><div align="center">
<select name="sumar_ue" onchange="sumar_ue()">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
</div></td>
<td><div align="center">
<select name="sumar_ue" onchange="sumar_ue()">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
</div></td>
<td><div align="center">
<select name="sumar_ue" onchange="sumar_ue()">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
</div></td>
<td><div align="center">
<select name="sumar_ue" onchange="sumar_ue()">
<option selected></option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select>
</div></td>
<td><input type="text" value="0" id="resultado_ue" size="10" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<br>
<input type="button" name="B3" value="Aceptar" onClick="verifica()">
</form></div>
</body>
</html>
muchas gracias......
