[PHP] - [Admin Control Panel w/ sessions] - [Gio]
#21
Posted 15 July 2005 - 07:58 AM
I havent use mysql so often and when i do its only copy and paste codes..
#22
Posted 11 August 2005 - 05:16 AM
#23
Posted 11 August 2005 - 04:38 PM
#24
Posted 18 August 2005 - 06:50 AM
this means what ? what should i insert here ...
#25
Posted 22 October 2005 - 06:01 PM
CREATE TABLE `login` ( `id` MEDIUMINT( 5 ) NOT NULL AUTO_INCREMENT , `username` VARCHAR NOT NULL , `pw` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM;
If iam wrong iam sure someone will post
EDIT: fixed
Edited by Shifty, 22 October 2005 - 06:03 PM.
#26
Posted 05 January 2006 - 05:40 PM
Like:
1 = News poster
2= Tutorial Writer
3= Moderator
4= Movie maker
Etc.
And on level 10 its admin, that has access to all
I mean, If you got level 4 you get access to 1,2,3 and 4.
If you have 1 you only got access to level 1..
You know what i mean ?
#27
Posted 03 February 2006 - 09:40 PM
Whats wrong?
#28
Posted 15 February 2006 - 01:52 PM
Actually Shifty, I hae just been working on it, and it seems to be the right SQL Inserts. So yes folks, this sql works as well.try,
CREATE TABLE `login` ( `id` MEDIUMINT( 5 ) NOT NULL AUTO_INCREMENT , `username` VARCHAR NOT NULL , `pw` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM;
If iam wrong iam sure someone will post
EDIT: fixed
Below is the SQL file you can just upload using your phpmyadmin.
If you look at the codes correctly people, you can easily tell whats what incase you want to make extra tables.
#29
Posted 25 February 2007 - 05:34 PM
Actually it does not work the same way.You could replace if (mysql_num_rows($result) == 0) with if(!$result).
Works just as well and saves some time
#30
Posted 05 August 2007 - 04:48 AM
CREATE TABLE `login` ( `id` bigint(255) NOT NULL auto_increment, `username` longtext NOT NULL, `pw` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; INSERT INTO `login` VALUES (2, 'admin', 'admin');
It's true?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users