inset into database mistake

[netrepsa]

The following gives me an error and I just cant see it.

=======================
$sql = "INSERT INTO Breed (group,breed,breedinfo,photo,temperament,heightweight,health,conditions,exercise,expectancy,grooming,origin,breedurl)
VALUES ('$group', '$breed', '$breedinfo ' ,'$photo','$temperament','$heightweight','$health','$conditions','$exercise','$expectancy','$grooming','$origin','$breedurl') " or die(mysql_error());
// run SQL against the DB

=======================

The error is:

---

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group,breed,breedinfo,photo,temperament,heightweight,health,con

[ahundiak]

group is a reserved word in mysql.
http://dev.mysql.com/doc/mysql/en/Reserved_words.html
Best to rename the column. You can also use back ticks around the column name.

[TheDefender]

[edit]
Obviously my post is no longer needed... Good catch ahundiak.
[/edit]