RE: [PHP-DB] MySql DB, help, sql error and i don't know why

the same thing and you can GROUP BY or ORDER BY on the VARCHAR without any conversion. > -Original Message- > From: David Rice [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 10:11 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] MySql DB, help, sql error and i

[PHP-DB] MySql DB, help, sql error and i don't know why

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