SQL Query insert problem

Pinkmischief

Hi guys i have written this code and for some reason it isnt inserting into a database and i jus cant see for the life of me why not :S
any help would be appreciated.
Btw the input form field is named claimid and the first field is named claimid.

function regcustomer(){
	if(isset($_POST['reg'])){
		$claimid = $_POST['claimid'];
		$sql = "INSERT INTO details ('claimid') VALUES ('$claimid')";
		$query = mysql_query ($sql);
		if (!$query){echo "<p>Could Not Insert!</p>";}else{echo "<p>Inserted!</p>";}
		echo $sql;
                     }
}

This is the response i get from that code

Could Not Insert!

INSERT INTO details ('claimid') VALUES ('vxbcvb')

Regards Pinky.

jansky

to check the error you can put to check your error
$query = mysql_query ($sql) or die(mysql_error()) ;

Roger_Ramjet

Most common causes of insert/update failures are table constraints

data would produce a duplicate key in a unique index
data supplied is wrong type or size for the field
other fields are required but no data supplied for them
referential integrity requires an entry in a related table and none exists.

rincewind456

You don't need single quotes around the field names

 $sql = "INSERT INTO details ('claimid') VALUES ('$claimid')";

should be

 $sql = "INSERT INTO details (claimid) VALUES ('$claimid')";

Roger_Ramjet

Ah yes, I missed that.