i cant find what is wrong? it says it sumits and it does but all i get is blank feilds in the database.
<form action="insert.php" method="post" name="post">
<p>Name:
<input name="name" type="text" id="name">
<br>
T ype:
<select name="type" id="type">
<option>ram</option>
<option>video</option>
<option>motherboard</option>
<option>software</option>
<option>harddrive</option>
<option>floppydraive</option>
<option>cd</option>
<option>network</option>
<option>accessories</option>
</select>
</p>
<p> Price:
<input name="price" type="text" id="price" value="$00.00">
</p>
<p> Info:
<textarea name="info" id="info"></textarea>
</p>
<p>on the next two where the "_______" is put the pics name </p>
<p>Big Pic:
<textarea name="pic" id="pic"><img src="_______" width="640" height="480"></textarea>
</p>
<p> Small pic:
<textarea name="smallpic" id="smallpic"><img src="itemspics/_____________" width="90" height="90"></textarea>
</p>
<p> </p>
<p>
<p>
<input type="submit" name="submit" value="submit">
</p>
</form>
<?
//Our PHP/MYSQL page.
//This script takes the data from the form
//fields and adds them to specified parts
//parts of the database
//MySQL Variables. Edit where necessary
$host = "localhost";
$login_name = "ecom";
$password = "*";
//Connecting to MYSQL
MySQL_connect("$host","$login_name","$password");
//Select the database we want to use
MySQL_select_db("ecom") or die("Could not select database");
//Assign contents of form to variables
$name = $POST['name'];
$info = $POST['info'];
$type = $POST['type'];
$price = $POST['price'];
$pic = $POST['pic'];
$smallpic = $POST['smallpic'];
$sql = "INSERT INTO video (info, pic, price, type, name, smallpic)
VALUES ('" . $info . "', '" . $pic . "','" . $price . "','" . $type . "','" . $name . "','" . $smallpic . "');";
$result = mysql_query($sql);
//Code to check if statement executed properly and display message
if ($result) {
echo("item has been added");
} else {
echo("An error has occured");
}
//Close connection with MySQL
MySQL_close()
?>
