Book ERROR: Unknown column 'Fredrik' in 'field list'

[fowler]

In confused with this problem, My code looks like this:

$sql="INSERT INTO calendar(year, month, day, name)
VALUES('$year','$month',".$GET['day'].",".$SESSION['name'].");

and the question is executed.

the table structure of "calendar" is

year TINYINT(4) notnull
month TINYINT(4) notnull
day TINYINT(4) notnull
name VARCHAR(30) notnull

I cant seem to grasp where the problem lies. Please help me!

[Lars_Berg]

You got it backwards, character values should be enclosed in ' not numeric values.