Well, I've got the same problem with the same script..Here is the code:
<?php
if ($_POST[op] != "add") {
//haven't seen the form, so show it
$display_block = "<h1>Add an Entry</h1>
<form method=\"post\" action=\"$_SERVER[PHP_SELF]\">
<P><strong>First/Last Names:</strong><br>
<input type=\"text\" name=\"f_name\" size=30 maxlength=75>
<input type=\"text\" name=\"l_name\" size=30 maxlength=75>
<P><strong>Address:</strong><br>
<input type=\"text\" name=\"address\" size=30>
<P><strong>City/State/Zip:</strong><br>
<input type=\"text\" name=\"city\" size=30 maxlength=50>
<input type=\"text\" name=\"state\" size=5 maxlength=2>
<input type=\"text\" name=\"zipcode\" size=10 maxlength=10>
<P><strong>Address Type:</strong><br>
<input type=\"radio\" name=\"add_type\" value=\"home\" checked> home
<input type=\"radio\" name=\"add_type\" value=\"work\"> work
<input type=\"radio\" name=\"add_type\" value=\"other\"> other
<P><strong>Telephone Number:</strong><br>
<input type=\"text\" name=\"tel_number\" size=30 maxlength=25>
<input type=\"radio\" name=\"tel_type\" value=\"home\" checked> home
<input type=\"radio\" name=\"tel_type\" value=\"work\"> work
<input type=\"radio\" name=\"tel_type\" value=\"other\"> other
<P><strong>Fax Number:</strong><br>
<input type=\"text\" name=\"fax_number\" size=30 maxlength=25>
<input type=\"radio\" name=\"fax_type\" value=\"home\" checked> home
<input type=\"radio\" name=\"fax_type\" value=\"work\"> work
<input type=\"radio\" name=\"fax_type\" value=\"other\"> other
<P><strong>Email Address:</strong><br>
<input type=\"text\" name=\"email\" size=30 maxlength=150>
<input type=\"radio\" name=\"email_type\" value=\"home\" checked> home
<input type=\"radio\" name=\"email_type\" value=\"work\"> work
<input type=\"radio\" name=\"email_type\" value=\"other\"> other
<P><strong>Personal Note:</strong><br>
<textarea name=\"note\" cols=35 rows=5 wrap=virtual></textarea>
<input type=\"hidden\" name=\"op\" value=\"add\">
<p><input type=\"submit\" name=\"submit\" value=\"Add Entry\"></p>
</FORM>";
} else if ($_POST[op] == "add") {
//time to add to tables, so check for required fields
if (($_POST[f_name] == "") || ($_POST[l_name] == "")) {
header("Location: addentry.php");
exit;
}
//connect to database
$conn = mysql_connect("localhost", "hari", "hari")
or die(mysql_error());
mysql_select_db("hari",$conn) or die(mysql_error());
//add to master_name table
$add_master = "insert into master_name values ('0', now(), now(),
'$_POST[f_name]', '$_POST[l_name]')";
mysql_query($add_master) or die(mysql_error());
//get master_id for use with other tables
$master_id = mysql_insert_id();
if (($_POST[address]) || ($_POST[city]) || ($_POST[state]) ||
($_POST[zipcode])) {
//something relevant, so add to address table
$add_address = "insert into address values ('0', $master_id,
now(), now(), '$_POST[address]', '$_POST[city]',
'$_POST[state]', '$_POST[zipcode]', '$_POST[add_type]')";
mysql_query($add_address) or die(mysql_error());
}
if ($_POST[tel_number]) {
//something relevant, so add to telephone table
$add_tel = "insert into telephone values ('0', $master_id,
now(), now(), '$_POST[tel_number]', '$_POST[tel_type]')";
mysql_query($add_tel) or die(mysql_error());
}
if ($_POST[fax_number]) {
//something relevant, so add to fax table
$add_fax = "insert into fax values ('0', $master_id, now(),
now(), '$_POST[fax_number]', '$_POST[fax_type]')";
mysql_query($add_fax) or die(mysql_error());
}
if ($_POST[email]) {
//something relevant, so add to email table
$add_email = "insert into email values ('0', $master_id,
now(), now(), '$_POST[email]', '$_POST[email_type]')";
mysql_query($add_email) or die(mysql_error());
}
if ($_POST[note]) {
//something relevant, so add to notes table
$add_note = "insert into personal_notes values ('0', $master_id,
now(), now(), '$_POST[note]')";
mysql_query($add_note) or die(mysql_error());
}
$display_block = "<h1>Entry Added</h1>
<P>Your entry has been added. Would you like to
<a href=\"addentry.php\">add another</a>?</p>";
}
?>
<HTML>
<HEAD>
<TITLE>Add an Entry</TITLE>
</HEAD>
<BODY>
<? print $display_block; ?>
</BODY>
</HTML>