input-php

<?php
include 'config.php';
$query = "SELECT grad FROM grad";
$result = mysql_query($query) or die(mysql_error()."[".$query."]");
?>
<form method="post" action="">
Фирма <input type="text" name="firma" /> <br />
Булстат <input type="text" name="bulstat" /> <br />
Град <select name="grad">
<?php
while ($row = mysql_fetch_array($result))
{
    echo "<option value=".$row['id'].">".$row['grad']."</option>";
}
?>
</select> <br />
Телефон <input type="text" name="telefon" /> <br />
Година <input type="text" name="godina" /> <br />
Лице за контакт <input type="text" name="lice" /> <br />
<input type="submit" name="submit" value="Добави" />
</form>

<?php
if(isset($_POST['submit'])){
$firma = $_POST['firma'];
$bulstat = $_POST['bulstat'];
$grad = $_POST['grad'];
$telefon = $_POST['telefon'];
$godina = $_POST['godina'];
$lice = $_POST['lice'];
$sql="INSERT INTO dostavchik (bulstat, firma, address, telefon, godina, lice) VALUES ('$bulstat', '$firma',  '$grad', '$telefon', '$godina', '$lice')";
$result = mysql_query($sql);
if (!$result)
{
die('Error: ' . mysql_error());
}
echo "Добавихте един запис.";
}
?>