Simple query help, What's wrong?

[oni-kun]

I have this code that I use to create the tables for my project of a video system.. Basically I want these fields, but it claims I use invalid syntax near desc/dateadded etc.. But I copied off an example and I can't see what's wrong.

// Create a MySQL table in the selected database
mysql_query("CREATE TABLE video(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
title VARCHAR(30), 
desc  VARCHAR(200), 
dateadded date,
filepath VARCHAR(200),
previewpic VARCHAR(200)
)")
or die(mysql_error());  

echo "Table Created!";

Is that how I'd create an entry for a date etc? I'm not sure why the syntax is wrong.

[seksislav]

mysql_query("CREATE TABLE video(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
title VARCHAR(30), 
`desc`  VARCHAR(200), 
dateadded date,
filepath VARCHAR(200),
previewpic VARCHAR(200)
)")
or die(mysql_error());  

echo "Table Created!";

 

DESC is used when ordering data so u have to escape it when using it as a column.

[oni-kun]

Thank you so much! I actually thought 'desc' was a reserved name, and accute accents were to define them. Thanks.