What's wrong with this SQL?
 

CREATE TABLE `transactions` (

`transaction_id` INT NOT NULL AUTO_INCREMENT ,
`FirstName` VARCHAR( 20 ) ,
`LastName` VARCHAR( 20 ) NOT NULL ,
`Email` VARCHAR( 20 ) ,
`Amount` DOUBLE( 20 ) NOT NULL ,
`ExtraDetails` VARCHAR( 500 ) ,
PRIMARY KEY ( `transaction_id` )
)

It doesn't like it for some reason?

Some reason? Your error message, which we can't see, probably says that there's a problem near so-and-so, and to check your docs.

Ah it's OK - I worked it would. Shouldn't have a number of characters by the double! Thanks for the reply though!

"It doesn't like it for some reason?"
I find it hilarious when people post a statement as a question... how would we know if it likes it or not?

Whenever I had to mess around with SQL, it was MySQL using PHPMyAdmin, it usually tells you exactly what's wrong, I liked that.