reload form

[cmadsen]

I am have trouble with the following code. It works fine the first time thru but will not reload the form for subsquent use

<?php

if($submit)
{
$link = mysql_connect ("mysql145.secureserver.net", "glamorous", "cem3956")
or exit ();
mysql_select_db ("glamorous")
or exit ();

echo $store;
$sql = "insert into store (store) values ('$store')";  

$result = mysql_query($sql);

mysql_close($link);
}
else
{

?>
<table width="800" border="0" cellpadding="0" cellspacing="0" summary="">
	<tr>
		<td align="center"><br><br><form method="post" action="store_form.php">
<b>Store Name: </b><input type="text" name="store"> <br>
<input type="submit" name="submit" value="insert"></form>
</td>
	</tr>
</table>
<?
}
?>

[Kudose]

Try

if(isset($_POST['submit']))
{
$link = mysql_connect ("mysql145.secureserver.net", "glamorous", "cem3956")
or die(mysql_error());
mysql_select_db ("glamorous")
or die(mysql_error());

echo $_POST['store'];
$sql = "insert into store (store) values ('$store')";  

mysql_query($sql) or die(mysql_error());

mysql_close($link);
}
else

Your main problems are that you are assuming register_globals in on and you aren't calling $result to execute the query.

[cmadsen]

I pluged your code in and tested. It didn't work. It did not bring up the form. it ran thru the insert part of the code first and never showed the form

[cmadsen]

the statement

if(isset($_POST['submit'])) 

is returning a 'true' after running thru the code once and I can't reset it to a false. I have tried unset ($submit); and still can't get the var set to false