[tlug] empty rows (PostgreSQL)

[Ahmed Sarwar <qqw99xk9@example.com>]

Hi, bellow is the form I can add data with. The porblem is 
it adds data even if the form is empty. How can I stop this?
Please reply if anyone have time. Thanks in advace.




<?
if ($_POST['submit'] != "Add")
{
  ?>
  <form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST">
  Name:<br>
        <input name="name" type="text" size="20">
        <p>
  <input type="submit" name="submit" value="Add">
  </form>
  <?
}
else
{
  $connection = pg_connect("dbname=db");


  if (!$connection)
    {
      die("Could not open connection to database server");
    }
  $query = "INSERT INTO name VALUES(nextval('name_id_seq'), '$name')";
  $result = pg_query($connection, $query) or die("Error in query:$query. " . pg_last_error($connection));
  echo "Data successfully added.";
  pg_close($connection);
}
?>