DB
CREATE TABLE IF NOT EXISTS `tabula` (
`id` int(11) NOT NULL auto_increment,
`niks` varchar(255) collate utf8_unicode_ci NOT NULL,
`skype` varchar(255) collate utf8_unicode_ci NOT NULL,
`komanda` varchar(255) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
index.php
<?
if($_POST['add']){
if($_POST['niks'] || $_POST['skype'] != ""){
$niks = mysql_real_escape_string($_POST['niks']);
$skype = mysql_real_escape_string($_POST['skype']);
$team = mysql_real_escape_string($_POST['team']);
mysql_query("INSERT INTO tabula(niks, skype, komanda) VALUES('$niks', '$skype', '$team')") or die(mysql_error());
echo"ok";
}else{echo"aizpildi visus laukus";}
}
?>
<form method="post">
Niks <input name='niks' type='text'><br/>
Skype <input name='skype' type='text'><br/>
Komanda <select name='team'>
<option value='komanda1'>Komanda1</option>
<option value='komanda2'>Komanda2</option>
</select>
<input name='add' type='submit'>