hi. quite new to mysql and ive stumbled accross a frustrating glitch. in creating my mysql table i get an error if i try to assign an int or decimal value to any of my fields. assigning a char value works but thats no good for me as i need to use values of my fields in php equations. the sql code i entered is as follows:

create table price (
frosted white decimal(6,2)not null,
silver mirror decimal(6,2)not null,
tinted mirror (grey, green, bronze) decimal(6,2) not null,
tinted mirror blue decimal(6,2)not null,
tinted mirror pink decimal(6,2)not null,
frosted mirror decimal(6,2) not null,
woodgrain (light, medium, dark) decimal(6,2) not null,
primary key(frosted white) )


And the error:

Error 1064: 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 'white decimal(6,2)not null, silver mirror decimal(6,2)not null, tinted mirror ' at line 2.

if i was to change all of decimal in the above sql commands to char(10) it would work. if i changed them to int(..) id get an error.

the mysql, php, and apache im using came bundled from www.apachefriends.com (xampp) and i wonder if its anything to do with that. i spent a long time trying to configure each program seperately but gave up after i found out xampp configured everything automatically in a few clicks.


Help would be much appreciated.


Mark

Have you tried DOUBLE ?

Try taking out the spaces in the table names...

silver_mirror

MySQL reads the space and is looking for the next keyword, at least that is my guess.

Thanks for getting back to me. Firstly i dont know what doubles are but ive rectified the problem by changing the numbers in my table headings (000-614,615-762 etc) to words ie- small medium large. strange because ive 3 books about mysql and none of them say anything about not being able to use numbers as headings..




edited: sorry what ive written above refers to an earlier version of the table i thought id posted up top there. looking at what i posted up there ive no idea what i did differently but it does work now. There is still spaces betweent he heading on my new table.