INSERT Problem with PHP

[passagewds]

I am trying to insert various fields into a MySql Database with PHP. When I put in the following script the php will write to the database,

$sql = "INSERT INTO $dbtable (Name, Url, Description) VALUES ('$Name', '$Url', '$Description')";

If I put in this script it won't input Anything into the database

$sql = "INSERT INTO $dbtable (Name, Url, Description, Group) VALUES ('$Name', '$Url', '$Description', '$Group')";

The only differences is that I have an extra field called Group. I have no idea why this won't work.

Here is the form tag for Group

<input name="Group" type="text" id="Group">

[TTT]

is [group] column [int]?
if it is, then:

$sql = "INSERT INTO $dbtable (Name, Url, Description, Group) VALUES ('$Name', '$Url', '$Description', $Group)";

[jdesilva]

what is the default value for Group?

[Lars_Berg]

Rename the column group.

[passagewds]

PERFECT... Thanks for the tip on the Reserved word

[ElMongol]

There's quite a few reserved words actually. Read More .

M.