[php-list] Cannot insert into db --- HELP!

[D. K. Wema]

I've tried to make the following script work but it
has totally failed. After many hours of frustration, I
kindly ask anyone who can help to save my day. The
script is supposed to insert data into the database
(mysql). When I enter the data and press the submit
button, the entered data disappears but nothing gets
to the database.

Here's the code:

<?php
include("include/dbconnect.php");
if($submit)
{

$sql = "INSERT INTO $table (firstname, lastname,
cpeyear, city, country, workplace, email, comments)
VALUES
('$firstname','$lastname','$cpeyear','$city','$country','$workplace','$email','$comments')";
$result = mysql_query($sql);
echo "<br><br>Information entered into address
book.\n";
}
else
{
?>

  <form method="post" action="<?php echo $PHP_SELF?>">
    <table width="440" border="0" cellspacing="1"
cellpadding="1">
      <tr>
        <td width="158">
          <input type="hidden" name="id" value="<?php
echo $myrow["id"]?>">
          Firstname:</td>
        <td width="275">
          <input type="Text" name="firstname"
size="30">
          </td>
      </tr>
      <tr>
        <td>Lastname:
          </td>
        <td>
          <input type="Text" name="lastname"
size="30">
          </td>
      </tr>
      <tr>
        <td>CPE/KCPE Year:</td>
        <td>
          <select name="cpeyear">
            <option value="1968">1968</option>
            <option value="1969">1969</option>
            <option value="1970">1970</option>
            <option value="1971">1971</option>
            <option value="1972">1972</option>
            <option value="1973">1973</option>
            <option value="1974">1974</option>
            <option value="1975">1975</option>
            <option value="1976">1976</option>
            <option value="1977">1977</option>
            <option value="1978">1978</option>
            <option value="1979">1979</option>
            <option value="1980"
selected>1980</option>
            <option value="1981">1981</option>
            <option value="1982">1982</option>
            <option value="1983">1983</option>
            <option value="1984">1984</option>
            <option value="1985">1985</option>
            <option value="1986">1986</option>
            <option value="1987">1987</option>
            <option value="1988">1988</option>
            <option value="1989">1989</option>
            <option value="1990">1990</option>
            <option value="1991">1991</option>
            <option value="1992">1992</option>
            <option value="1993">1993</option>
            <option value="1994">1994</option>
            <option value="1995">1995</option>
            <option value="1996">1996</option>
            <option value="1997">1997</option>
            <option value="1998">1998</option>
            <option value="1999">1999</option>
            <option value="2000">2000</option>
            <option value="2001">2001</option>
            <option value="2002">2002</option>
            <option value="2003">2003</option>
          </select>
          </td>
      </tr>
      <tr>
        <td>City:
          </td>
        <td>
          <input type="Text" name="city"  size="50">
          </td>
      </tr>
      <tr>
        <td>Country:</td>
        <td>
          <input type="Text" name="country" 
size="50">
          </td>
      </tr>
      <tr>
        <td>Workplace</td>
        <td>
          <input type="Text" name="workplace" 
size="70">
          </td>
      </tr>
      <tr>
        <td>Email:
          </td>
        <td>
          <input type="Text" name="email" size="35" 
size="40">
          </td>
      </tr>
      <tr>
        <td>Any comments: </td>
        <td>
          <textarea name="comments" rows="5"
cols="40"></textarea>
          </td>
      </tr>
    </table>
    <input type="Submit" name="submit" value="Submit
information">
  </form>
  <?
}
?>


Thanks in advance,
dk


                
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com


------------------------ Yahoo! Groups Sponsor --------------------~--> 
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/HKFolB/TM
--------------------------------------------------------------------~-> 

Community email addresses:
  Post message: php-list@yahoogroups.com
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-list/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/