php noticia y formulario por MySQL

[camilo_1987]

hola todas noticia y formulario MySQL

Código:

CREATE TABLE `noticia` (
  `id` int(11) NOT NULL auto_increment,
  `Fecha` varchar(50) collate latin1_spanish_ci NOT NULL,
  `Titulo` varchar(50) collate latin1_spanish_ci NOT NULL,
  `Texto` text collate latin1_spanish_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=7 ;

Código PHP:

  <form id="form1" name="form1" method="post" action="noticianuevo.php"> 
<table width="39%" border="0" cellpadding="0" cellspacing="0" align="center"> 
  <tr> 
    <td>TITULO: 
      <label> 
      <input name="textfield" type="text" id="textfield" size="49" /> 
      </label></td> 
  </tr> 
  <tr> 
    <td>FECHA: 
      <label> 
      <input name="textfield2" type="text" id="textfield2" size="50" /> 
      </label></td> 
  </tr> 
  <tr> 
    <td><label> 
      <div align="center"> 
        <textarea name="textfield3" cols="50" rows="10" id="textfield3"></textarea> 
        </div> 
    </label></td> 
  </tr> 
  <tr> 
    <td><label> 
      <div align="center"> 
        <input type="submit" name="button" id="button" value="Enviar" /> 
        </div> 
    </label></td> 
  </tr> 
</table> 
</form>  
   

gacias