This code has been tested and will work, let me know how it does for what you are trying to do.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Add referee</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
if($_POST['submit'])
{
$number = $_POST['number'];
$name = $_POST['name'];
$telephone = $_POST['telephone'];
$db = mysql_connect('localhost','haivenu_xx12313','i12323')
or die(mysql_errno().' : '.mysql_error());
mysql_select_db('haivenu_test')
or die(mysql_errno().' : '.mysql_error());
$sql = "INSERT INTO referees (number, name, telephone)
VALUES ('$number','$name','$telephone')";
$result =mysql_query($sql)
or die("Could not execute query".mysql_error());
mysql_close($db);
echo "Added $name to database\n";
}
?>
<form method="post" action="<?php echo $PHP_SELF;?>">
<table cellpadding="6" cellspacing="0">
<tr>
<td>Number :</td>
<td><input name="number" type="text" id="number" size="5" /></td>
</tr>
<tr>
<td>Name :</td>
<td><input type="text" name="name" /></td>
</tr>
<tr>
<td>Telephone :</td>
<td><input type="text" name="telephone" /></td>
</tr>
<tr>
<td> </td>
<td>
<input type="submit" name="submit" value="Add Referee" />
<input type="reset" name="reset" value="Clear" />
</td>
</tr>
</table>
</form>
</body>
</html>
Here is the database with some changes to the structure. I assigned 4 for the value of integers which gives you 9,999 or 10,000 if you count 0 then I assigned the tellephone number to a varchar because people sometimes enter characters other than integers, the way you had it if some one entered 615-456-7890 it would have put a blank in the database with a varchar it wil put 615-456-7890 in there, also someimes you might need to call an office with an extension like 130 so they might enter 456789 ext 130 with integers nothing would be entered into the database. I also changed the name field to varchar(40) since very few people have names much longer than that and reserving a text field of 64K for just a name did not make much sense.
DROP TABLE `referees`;\\You don't need to do this unless you are still testing
CREATE TABLE `referees` (
`id` int(4) unsigned NOT NULL auto_increment,
`number` int(4) NOT NULL default '0',
`name` varchar(40) NOT NULL,
`telephone` varchar(15) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `number` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `referees`
--
INSERT INTO `referees` VALUES (1, 1, 'Thanh Nguyen', '915678976');
INSERT INTO `referees` VALUES (2, 2, 'Haivenu', '9272917');
INSERT INTO `referees` VALUES (3, 3, 'Nguyen Tat Thanh', '912853450');
INSERT INTO `referees` VALUES (4, 4, 'thanh nguyen', '34683402');
