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>