form to input data to mySQL

[g0dzuki]

Hopefully someone can show me what I'm doing wrong here. I have a simple form that when you click submit it enters the data into mySQL. It works as much as entering a new row in the DB but no data is included... here's what I have.

here's the form:

<form name="addentry" method="post" action="submit.php">
Enter Application: <input type="text" name="Product"><BR>
Enter Version: <input type="text" name="ProductVersion"><BR>
<input name="submit" value="Submit" type="submit">
</form>

and here is submit.php

<?PHP
include "dbconnect.php";	
$query = "INSERT INTO data (Product , ProductVersion)
	VALUES('$Product','$ProductVersion')";
$result = mysql_query($query);
echo "Item Entered";
?>

I have verified that it is connecting to the database succefully and data is entered if I replace the vars with static entries. My guess is that I'm doing something wrong with getting the vars from the form to 'submit'.

Anyone have any idea what I'm missing? I appreciate all responses.

~ Chris

[rIkLuNd]

You might have to like this:

<?PHP
include "dbconnect.php";    

# For php version 4.1.0 the you should use $_POST, and
# on older versions $HTTP_POST_VARS

$query = "INSERT INTO data (Product,ProductVersion)
    VALUES('$_POST[Product]','$_POST[ProductVersion]')";
$result = mysql_query($query);
echo "Item Entered";
?>

If that one doesn't work, then try this one:

<?PHP
include "dbconnect.php";    

# For php version 4.1.0 the you should use $_POST, and
# on older versions $HTTP_POST_VARS

$query = "INSERT INTO data (Product,ProductVersion)
    VALUES('$HTTP_POST_VARS[Product]','$HTTP_POST_VARS[ProductVersion]')";
$result = mysql_query($query);
echo "Item Entered";
?>

[g0dzuki]

Your first suggestion worked great!

Thanks!

[rIkLuNd]

You're welcome!