I got some help w/ part of the problem, but now this is happening.
1) The code is inserting a new row into 'bands' without inserting the value the user input into the text field
2) When I tried it again after the new was created, it said that a primary already existed.
I've looked through my code, but am not familiar enough with PHP to figure out why. Can you tell?
<html>
<head>
<body bgcolor="#000000">
<?php
include ('head.asp');
include ('misc.inc');
?>
<form action="processform.php" action="post">
<p>
Name:<input type="text" name="name">
</p><p>
<input type="submit" value="Send">
<input type="reset" value="Clear">
</p>
</form>
</body>
</head>
</html>
<html>
<head>
<title>processform</title>
<?php
include ('misc.inc');
include ('head.asp');
$name = $HTTP_POST_VARS['name'];
/ connect to server(mysql) with pconnect for persistent
connection, not to close then reconnect /
mysql_pconnect("$host","$user","$password")
or die ("Couldn't connect to the server.");
/ connect to db (seattlebands) /
mysql_select_db("seattlebands")
or die ("Couldn't connect to the database.");
/ add row to table 'bands' and insert input values /
$query = "INSERT INTO bands (name) VALUES ('$name')";
$result = mysql_query($query)
or die (mysql_error());
echo "$name";
?>
</body>
</head>
</html>
