you're insert query is wrong:
it should be:
PHP Code:
$query = "INSERT INTO entries ('id', 'title', 'content', 'date') VALUES('', 'my_title', 'my_content', 'my_date')";
// or:
$query = "INSERT INTO entries VALUES('', 'my_title', 'my_content', 'my_date')";
// or:
$query = "INSERT INTO entries SET title='my_title', content='my_content', date='my_date'";
the reason why you got this error is because you were assigning a string to an integer type: id was an int(4) NOT NULL auto_increment, not a string
UnrealEd