Insert guery not inserting

Databases
1

Why will this insert query work

$insert = "INSERT INTO log (name, pin)

 			VALUES ('".$_POST['name']."', '".$_POST['pin']."')";

 	$add_member = mysql_query($insert);

the above query works fine but when I wanted to go back and add fields to the form and bd the new insert query does not insert but it shows that the form was submitted and posted to the db.

this is the new query with the added fields

$insert = "INSERT INTO log (name, pin, group, kids)

 			VALUES ('".$_POST['name']."', '".$_POST['pin']."', '".$_POST['group']."', '".$_POST['kids']."')";

 	$add_member = mysql_query($insert);
2

please, always test your query in mysql before trying to parameterize it in php

you will find that GROUP is a reserved word

3

Thanks r937, I changed the name and it works. I will test in mysql first from now on.