Insert Statement

[Anon]

Can someone please tell me why this insert statement only insert records some of the time. I don't understand. It will insert a new record then when I try to insert a record right after that it will not insert into the database.

Please help

$query = "INSERT into tblProperties (Neighborhood, Address, City, State, ZipCode, Price, BedRooms, Bathrooms, SqFeet, Status, Description, Type, ImageName, ContactID_FK, Available) VALUES ('$Neighborhood', '$Address', '$City', '$State', $Zip, '$Price', $NumOfBeds, $NumOfBaths, $SquareFeet, '$Status', '$Description', '$Type', '$ImageName', $ContactName, '$Available')";

$result = mysql_query($query,$link);

[Anon]

Do you have any not null, or unique fields in your table? Maybe you are running into one of these constraints.