bueno e creado este formulario para que me mande los datos a la bd pero no los manda el formulario dice que si pero no me aparesen en la base de datos les dejo el codigo gracias de antemano
<? include("conectar.php"); ?>
<?
if (isset($_POST['enviar'])) {
if ($_POST['nick'] != "" && $_POST['r1'] != "" && $_POST['r2'] != "" && $_POST['r3'] != "" && $_POST['r4'] != "" && $_POST['r5'] != "") {
$id = "";
$query = "INSERT INTO `nominar` (`nick` ,`1` ,`2` ,`3` ,`4` ,`5`) VALUES ('".$_POST['nick']."', '".$_POST['r1']."', '".$_POST['r2']."', '".$_POST['r3']."', '".$_POST['r4']."', '".$_POST['r5']."',)";
@mysql_query($query);
echo "<div align=center><font color=#cc0000>Mensaje enviado</font><br><a href=\"panel.php?mostrar=enviarprivado&".session_name()."=".session_id()."\" class=\"EnlaceMenu\">"._RETURN."</a></div>";
} else
echo "<font class=\"Texto\">Has dejado algún campo vacío<br></font><a href=\"panel.php?mostrar=enviarprivado&".session_name()."=".session_id()."\" class=\"EnlaceMenu\">"._RETURN."</a>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>cxbshxc</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="">
<table width="100%" border="0">
<tr>
<td>Nick</td>
<td><input name="nick" type="text" id="nick"></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r1" class="Select" id="r1">
<option value="carlos">carlos</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r2" class="Select" id="r2">
<option value="carlos">carlos</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r3" class="Select" id="r3">
<option value="caelos">carlos</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r4" class="Select" id="r4">
<option value="cnsac">camcnsacj</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r5" class="Select" id="r5">
<option value="ncjc">scnjc</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td> </td>
<td><input name="enviar" type="submit" id="enviar" value="Enviar"></td>
</tr>
</table>
</form>
</body>
</html>
