mattireland

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?

__________________
Matt Ireland
http://www.mattireland.org
matt@mattireland.co.uk

DaWei

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.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

mattireland

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

__________________
Matt Ireland
http://www.mattireland.org
matt@mattireland.co.uk

Komodo

"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.