PLEASE CHECK OUT THE SECOND VIDEO OF THIS
A quick and easy user registration using php, sql and phpmyadmin.
For full size and source codes: http://www.neoblob.com/phpsquad/tuts/php/1/
SQL:
CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Channel: Howto & Style Uploaded: October 1, 2006 at 4:21 pm Author:lifeg0eson666
Insert your meat in my hot oven..
_DATEHERWOW -DOT- COM_
MyMusicFilms(Wednesday 31st of December 2008 06:52:06 AM)
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL: CREATE TABLE `user` ( `id` int(10) unsigned NOT NULL auto_increment, `us' at line 1
VonCarlsson(Saturday 27th of December 2008 10:43:52 AM)
Always quote your fucking variables!
$dbname = "database";
..
Smatchimo(Monday 22nd of December 2008 04:54:33 PM)
dude if you went into the method of all that while you were doing it you could already be making bank just teaching this stuff.
virusmaker28(Monday 22nd of December 2008 05:22:56 AM)
nice tut 5/5 but you should use an editor...and btw when you get errors it usually sais what line has errors...