#1 [PHP] Form con <select><option>
Me inserta vacia la informacion cuando la mando, no encuentro el problema =S
aqui les dejo el codigo...
************************************************** *****************
usuarios.php
<?php
include("row.php");
?>
<form method="post" action="usuarios.php">
<label>
<input type="submit" value="Submit">
</label>
</form>
************************************************** ****************
row.php
echo "<td>
<select name='autoins'>
<option value='NO'>NO</option>
<option value='YES'>YES</option>
</select>
</td>";
echo "<td>
<select name='fctry'>
<option value='NO'>NO</option>
<option value='YES'>YES</option>
</select>
</td>";
etc...
if (isset($_POST['autoins'])) {
$auto = $_POST['autoins'];
$fact = $_POST['fctry'];
$mnfg = $_POST['mnfg'];
$npi = $_POST['npi'];
$plan = $_POST['plan'];
$prchase = $_POST['prchase'];
$qlty = $_POST['qlty'];
$test = $_POST['test'];
$q = ("INSERT INTO emerson.optionusrs (autoinsercion,factoryproduct,manufact,npi,plannin g,purchasing,quality,test) VALUES ('$auto','$fact','$mnfg','$npi','$plan','$prchase' ,'$qlty','$test')");
$query = mysql_query($q) or die ("SQL error: ".mysql_error());
Saludos..!
aqui les dejo el codigo...
************************************************** *****************
usuarios.php
<?php
include("row.php");
?>
<form method="post" action="usuarios.php">
<label>
<input type="submit" value="Submit">
</label>
</form>
************************************************** ****************
row.php
echo "<td>
<select name='autoins'>
<option value='NO'>NO</option>
<option value='YES'>YES</option>
</select>
</td>";
echo "<td>
<select name='fctry'>
<option value='NO'>NO</option>
<option value='YES'>YES</option>
</select>
</td>";
etc...
if (isset($_POST['autoins'])) {
$auto = $_POST['autoins'];
$fact = $_POST['fctry'];
$mnfg = $_POST['mnfg'];
$npi = $_POST['npi'];
$plan = $_POST['plan'];
$prchase = $_POST['prchase'];
$qlty = $_POST['qlty'];
$test = $_POST['test'];
$q = ("INSERT INTO emerson.optionusrs (autoinsercion,factoryproduct,manufact,npi,plannin g,purchasing,quality,test) VALUES ('$auto','$fact','$mnfg','$npi','$plan','$prchase' ,'$qlty','$test')");
$query = mysql_query($q) or die ("SQL error: ".mysql_error());
Saludos..!
0