$HTTP_POST_VARS['Description'] Doesn't work

wdermott

But what do I replace it with? How do I get the value from the field on the form into the php code ? I've tried $_POST_VARS[] but that doesn't work either.

TIA
Wayne

<html>
<body>
<?php
$Description = $HTTP_POST_VARS['Description'] or die("Could not set variable");
@ $db = mysql_pconnect('localhost', 'root', 'cilegon');
mysql_select_db('ansi');
$query = "insert into ansi values ('".$Description."')" or die("Could not execute query");
echo mysql_affected_rows().' ANSI inserted into database.';
?>
</body>
</html>

Pig

You should use $_POST['var']

Do an echo before you do an SQL, and make sure it is displaying properly. Also, when you insert into a db, it should be in the format:
INSERT INTO table_name (field_name) VALUES ('value');

TTT

HTTP_POST_VARS should work, but sometimes you have to use $HTTP_GET_VARS['Description']

also you have an error in sql statement
insert into ansi values ('".$Description."')" or die("Could not execute query");

[syntax]INSERT INTO table (a,b) VALUES (1,2)[/syntax]