SQL string with space?

[sveegaard]

Hi,
How do I store a space-containing string in MySQL? When I try to store e.g. "Steffen Sveegaard", MySQL returns an error! The variable is wrapped in "'s in the query.

[dee-u]

What is the error raised?

[sveegaard]

"You have an error in your SQL syntax near 'Sveegaard (id int (255) not null primary key auto_increment, dato varchar (75) ' at line 1" while creating a new table