Error inserting dates

[moret]

Hello, I've created a page with a form for inserting dates in a data base. Also, there is the delete option, but this works well. The problem is with inserting. Here I write the files:

tutadmin.php:

<?php
require ("config.php");
?>
<H1>Insertar categoría</H1>
<FORM ACTION="tutinsertar.php?op=cat">
<TABLE>
<TR>
<TD>ID:</TD>
<TD><INPUT TYPE="text" NAME="id" SIZE="20" MAXLENGTH="5"></TD>
</TR>
<TR>
<TD>Título:</TD>
<TD><INPUT TYPE="text" NAME="titulo" SIZE="20"></TD>
</TR>
<TR>
<TD>Descripción:</TD>
<TD><INPUT TYPE="text" NAME="descripcion" SIZE="20"></TD>
</TR>
</TABLE>
<br>
<INPUT TYPE="submit" NAME="accion" VALUE="Insertar">
</FORM>
<hr>
<?php
$resultcat=mysql_query("select * from tutoriales_cat",$link);
?>
<TABLE BORDER=1 CELLSPACING=1 CELLPADDING=1>
<TR><TD>&nbsp;<B>ID</B></TD><TD>&nbsp;<B>Título</B></TD><TD>&nbsp;<B>Descripción</B></TD></TR>
<?php

while($row = mysql_fetch_array($resultcat)) {
printf("<tr><td>&nbsp;%s</td> <td>&nbsp;%s&nbsp;</td> <td>&nbsp;%s&nbsp;</td><td><a href=\"tutsuprimir.php?op=cat&id=%d\">Borrar</a></td></tr>", $row["id"], $row["titulo"], $row["descripcion"], $row["id"]);
}
mysql_free_result($result);
mysql_close($link);

?>
</table>

<H1>Insertar artículo</H1>
<FORM ACTION="tutinsertar.php?op=art">
<TABLE>
<TR>
<TD>ID:</TD>
<TD><INPUT TYPE="text" NAME="id" SIZE="20" MAXLENGTH="5"></TD>
</TR>
<TR>
<TD>ID de la categoría:</TD>
<TD><INPUT TYPE="text" NAME="id_cat" SIZE="20" MAXLENGTH="5"></TD>
</TR>
<TR>
<TD>Título:</TD>
<TD><INPUT TYPE="text" NAME="titulo" SIZE="20"></TD>
</TR>
<TR>
<TD>Descripción:</TD>
<TD><INPUT TYPE="text" NAME="descripcion" SIZE="20"></TD>
</TR>
<TR>
<TD>Artículo:</TD>
<TD><INPUT TYPE="text" NAME="articulo" SIZE="20"></TD>
</TR>
<TR>
<TD>Autor:</TD>
<TD><INPUT TYPE="text" NAME="autor" SIZE="20" MAXLENGTH="50"></TD>
</TR>
<TR>
<TD>Email:</TD>
<TD><INPUT TYPE="text" NAME="email" SIZE="20" MAXLENGTH="50"></TD>
</TR>
<TR>
<TD>Fecha:</TD>
<TD><INPUT TYPE="text" NAME="fecha" SIZE="20" MAXLENGTH="10"></TD>
</TR>
</TABLE>
<br>
<INPUT TYPE="submit" NAME="accion" VALUE="Insertar">
</FORM>
<hr>
<?php
$resultart=mysql_query("select * from tutoriales",$link);
?>
<TABLE BORDER=1 CELLSPACING=1 CELLPADDING=1>
<TR><TD>&nbsp;<B>ID</B></TD> <TD>&nbsp;<B>ID de la categoría</B></TD><TD>&nbsp;<B>Título</B></TD><TD>&nbsp;<B>Descripción</B></TD><TD>&nbsp;<B>Artículo</B></TD><TD>&nbsp;<B>Autor</B></TD><TD>&nbsp;<B>Fecha</B></TD><TD>&nbsp;<B>Email</B></TD></TR>
<?php

while($row = mysql_fetch_array($resultart)) {
printf("<tr><td>&nbsp;%s</td> <td>&nbsp;%s&nbsp;</td> <td>&nbsp;%s&nbsp;</td> <td>&nbsp;%s&nbsp;</td> <td>&nbsp;%s&nbsp;</td> <td>&nbsp;%s&nbsp;</td> <td>&nbsp;%s&nbsp;</td> <td>&nbsp;%s&nbsp;</td><td><a href=\"tutsuprimir.php?op=art&id=%d\">Borrar</a></td></tr>", $row["id"], $row["id_cat"], $row["titulo"], $row["descripcion"], $row["articulo"], $row["autor"], $row["email"], $row["fecha"], $row["id"]);
}
mysql_free_result($result);
mysql_close($link);

?>

</table>

tutinsertar.php

<?php

$op=$_GET['op'];
require("config.php");

if ($op==art){

$id=$GET['id'];
$id_cat=$GET['id_cat'];
$titulo=$GET['titulo'];
$descripcion=$GET['descripcion'];
$articulo=$GET['articulo'];
$autor=$GET['autor'];
$email=$GET['email'];
$fecha=$GET['fecha'];

mysql_query("insert into tutoriales (id,id_cat,titulo,descripcion,articulo,autor,email,fecha) values ('$id','$id_cat','$titulo','$descripcion','$articulo','$autor','$email','$fecha')",$link);

}elseif($op==cat){

$id=$GET['id'];
$titulo=$GET['titulo'];
$descripcion=$_GET['descripcion'];

mysql_query("insert into tutoriales_cat (id,titulo,descripcion) values ('$id','$titulo','$descripcion')",$link);

}

header("Location: tutadmin.php");

?>

Thanks!!

[Roger_Ramjet]

Use POST instead of GET.

<FORM ACTION="tutinsertar.php" method="post" name="cat_insert">

<input type="hidden" name="op" value="cat"> 

// etc, then tutinsertar.php

$op=$_POST['op'];

if ($op=='cat') {
   $id=$_POST['id'];

// etc

// But, more elegently

foreach ($_POST as $key=>$val) {
$_SESSION[$key]=$val;
	}

 mysql_query("insert into tutoriales (id,id_cat,titulo,descripcion,articulo,autor,email
,fecha) values ('$id','$id_cat','$titulo','$descripcion','$articu
lo','$autor','$email','$fecha')",$link);


// all post vars are then set as session vars and can be used by name without the  $id=$_POST['id']

[/code]

[Roger_Ramjet]

If you still are not entering the data then echo out the query string to see exactly what you are sending to the db.

$sql = "insert into tutoriales  (id,id_cat,titulo,descripcion,articulo,autor,email

,fecha) values  ('$id','$id_cat','$titulo','$descripcion','$articu

lo','$autor','$email','$fecha')";

echo $sql

$result = mysql_query($sql) or die($sql . '<br />' . mysql_error());

[moret]

Thanks!! I have it, and now it works!! Thanks!!