Having trouble inserting records to a table.

[contraband]

currently i am using the code:

$query ="INSERT INTO table_name (Field_name) VALUES ($name)";
$result = mysql_query($query);

and it doesnt seem to be inserting.

am i doing it wrong?

thanks in advance,

andy

[coopster]

Welcome to WebmasterWorld, contraband.

String values should be quoted.

$query ="INSERT INTO table_name (Field_name) VALUES ('$name')";

Note the single quotation marks around the $name variable.

[dreamcatcher]

Also use mysql_error to show errors:

$result = mysql_query($query) or die(mysql_error());

dc