PDA

View Full Version : mysql error from tutorial link inside to help my poor explanation


hansolo
06-20-2010, 08:14 PM
my sql script
content is that reffering to the table name

'my file' i thought that would be the name of the field in the content



SELECT content FROM file WHERE filename='myfile';

link to tutorial
http://www.kirupa.com/developer/actionscript/flash_php_mysql2.htm


i recieve this error below in mysql

Error

SQL query:

CREATE TABLE `databasescores`.`content` (
`myfile ` VARCHAR( 10 ) NOT NULL
) ENGINE = MYISAM ;

MySQL said: Documentation
#1166 - Incorrect column name 'myfile '