PDA

View Full Version : mysql help



madchild24
14-11-2005, 10:33 PM
We will use a database to store all the user information in. Once you have created a database, go to phpmyadmin and run this query:

Code
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(30) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`msn` varchar(250) NOT NULL default 'Not Specified',
`aim` varchar(250) NOT NULL default 'Not Specified',
`location` varchar(36) NOT NULL default 'Not Specified',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
how i do that?

Want to hide these adverts? Register an account for free!