Hey,
I am having a problem with a page that insert's data into the database.
Everytime I refresh the page it adds blank data into the database.
Im guessing I need some sort of if ($submit) or something but cant get it to work.
Here is my code.
<head><title>Links Database</title>
</head>
<body bgcolor=#ffffff>
<center>
<h1>Add</h1>
<form>
Letter: <select name="letter">
<option value="0-9">0-9</option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
<option value="E">E</option>
<option value="F">F</option>
<option value="G">G</option>
<option value="H">H</option>
<option value="I">I</option>
<option value="J">J</option>
<option value="K">K</option>
<option value="L">L</option>
<option value="M">M</option>
<option value="N">N</option>
<option value="O">O</option>
<option value="P">P</option>
<option value="Q">Q</option>
<option value="R">R</option>
<option value="S">S</option>
<option value="T">T</option>
<option value="U">U</option>
<option value="V">V</option>
<option value="W">W</option>
<option value="X">X</option>
<option value="Y">Y</option>
<option value="Z">Z</option>
</select><br>
Name Of Show: <input type=text name='name'><br>
Official Site: <input type=text name='olink'><br>
Episode Guide: <input type=text name='elink'><br>
Imdb: <input type=text name='ilink'><br>
Search Category Link: <input type=text name='catlink'><br>
Search Category Name: <input type=text name='catname'><br>
<input type=submit value="Add Show">
</form>
<br>
<?
include("config.php");
$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
$query = "INSERT INTO $table ( name, catname, catlink, olink, elink, ilink, letter ) VALUES ('$name', '$catname', '$catlink', '$olink', '$elink', '$ilink', '$letter')";
$result = mysql_db_query("tvlinks", $query);
if ($result) {
echo "<p><b>$name</b> was added to the database</p>";
}
?>
<br>
<a href="tvlinks.php">Tv Homepage</a>
<br>
<br>
<a href="admin.php">Tv Admin Center</a>
</center>
</body>
Any help would be great. Thanks
