PDA

View Full Version : New to databases, simple setup error, plz help :(



DanielJPayne
01 Feb 2006, 11:46 AM
im using phpmyadmin heres wot i get cum up

CREATE TABLE `products` (

`name` CHAR( 255 ) UNSIGNED,
`category` CHAR( 255 ) ,
`manufacturer` CHAR( 255 ) ,
`type` CHAR( 255 ) ,
`group` CHAR( 255 ) ,
`price` DECIMAL( 6 ) UNSIGNED,
`smalldesc` CHAR( 255 ) UNSIGNED,
`fulldesc` VARCHAR( 1000 ) UNSIGNED,
`smallimage` CHAR( 255 ) UNSIGNED,
`largeimage` CHAR( 255 ) UNSIGNED,
`stock` SMALLINT( 2 ) UNSIGNED,
FULLTEXT (
`name` ,
`category` ,
`manufacturer` ,
`type` ,
`group`
)
) COMMENT = 'Product Generation Database'

You have an error in your SQL syntax near 'UNSIGNED, `category` CHAR(255), `manufacturer` CHAR(255), `type` CHAR(255), `gro' at line 1

wot does this mean please. thankyou

DanInManchester
02 Feb 2006, 03:45 PM
you can't have an unsigned varchar.
unsigned refers to a number e.g. -1 or 1
an unsigned number does not have a + or -