[snoj]

For a challenge and maybe a Christmas present for my dad, I decided to make a php script that can handle his bill storage, making, and searching needs. Well I'm new to php and newer to forms. Anyway so far my script queries the DB for current client entries (so far just returns "test") and places a form at the bottom to enter new clients. Anyway when I reload the page the same $name and $address variables are loaded into the DB! As you can see from my script I've tried sessions and unset(), but non have worked. So either I'm doing it wrong or I'm not even on the right track.

Any help will be very appreciated.

<?php
session_id();
session_start();
include("mysql.php");

$db1a=mysql_query("SELECT * FROM categories WHERE parent_id = 0");
while($db1=mysql_fetch_array($db1a))
	{
  echo "test<br>";
	}
echo("<hr width=\"50%\" align=\"left\">");
echo("<b>Enter new client</b><br>
<form action=\"{$PHP_SELF}\" method=\"POST\">
<input type=hidden name=\"redirect\" 
value=\"index.php\">
Name: <input type=\"text\" name=\"name\" size=\"30\" maxlength=\"256\"><br>
Address: <input type=\"text\" name=\"address\" size=\"30\" maxlength=\"256\"><br>
<input type=\"submit\" name=\"submit\" value=\"Enter information\">
</form>");

if($submit)
	{
  if($name == "")
 	 {
    echo("Sorry you have to enter a name!");
 	 }
  if($address == "")
 	 {
    echo("Sorry you have to enter an address!");
 	 }
//  $sql=mysql_query("INSERT INTO categories (name, address) VALUES ('{$name}','{$address}')");
//  unset($name, $address);

	}
session_unset();
session_destroy();
?>

[snoj]

Fixed. Just used header("Location: redirect.html");