use `Address` TEXT NOT NULL , Jochem David Rice wrote:
SQL-query :
CREATE TABLE `staff` (
`StaffId` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Name` VARCHAR( 30 ) NOT NULL ,
`Surname` VARCHAR( 30 ) NOT NULL ,
`Address` TEXT( 225 ) NOT NULL ,
`JobId` SMALLINT( 2 ) NOT NULL ,
`PermissionId` SMALLINT( 2 ) NOT NULL ,
`HomePhone` INT( 11 ) NOT NULL ,
`MobilePhone` INT( 11 ) NOT NULL ,
`TipsPoints` INT( 1 ) NOT NULL ,
`DOB` DATE NOT NULL ,
`Password` VARCHAR( 20 ) NOT NULL ,
`ResterauntId` INT( 1 ) NOT NULL ,
`DateStarted` DATE NOT NULL ,
`StaffStatusId` TINYINT( 1 ) NOT NULL
)
MySQL said:
You have an error in your SQL syntax near '(225) NOT NULL, `JobId` SMALLINT(2) NOT NULL, `PermissionId` SMALLINT(2) NOT NUL' at line 1
_________________________________________________________________
MSN 8: advanced junk mail protection and 2 months FREE*. http://join.msn.com/?page=features/junkmail
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
