Thread: query synatx
View Single Post
Old 07-18-2008, 06:19 PM   #2 (permalink)
drewbee
The Acquainted
 
drewbee's Avatar
 
Join Date: May 2008
Posts: 175
Thanks: 9
drewbee is on a distinguished road
Default

Try this:
Code:
CREATE TABLE IF NOT EXISTS `users` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 255 ) NOT NULL ,
`password` VARCHAR( 255 ) NOT NULL ,
`email` TEXT NOT NULL ,
`ip` VARCHAR( 16 ) NOT NULL ,
`group` INT( 1 ) NOT NULL DEFAULT '1',
`banned` VARCHAR( 5 ) NOT NULL DEFAULT 'n',
PRIMARY KEY ( `id` ) 
) ENGINE = MYISAM
__________________
There are No Stupid Questions. But there a LOT of Inquisitive Idiots.
Send a message via AIM to drewbee
drewbee is offline  
Reply With Quote
The Following User Says Thank You to drewbee For This Useful Post:
Evulness (07-18-2008)