[code]-- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `admin_id` int(25) NOT NULL auto_increment, `username` varchar(25) NOT NULL default '', `password` varchar(100) NOT NULL default '', `email_address` varchar(250) NOT NULL default '', PRIMARY KEY (`admin_id`) ) TYPE=MyISAM COMMENT='Admin Users' AUTO_INCREMENT=4 ; -- -- Dumping data for table `admin` -- INSERT INTO `admin` VALUES (1, 'admin1', 'c56594001e03e8ccb5870e0e2df5c0e7', 'azziman@hotmail.com'); INSERT INTO `admin` VALUES (2, 'admin2', 'cbb2d5a9b5e6e8421452bbbdfd01034f', 'azziman0@hotmail.com'); -- -------------------------------------------------------- -- -- Table structure for table `lecturer` -- CREATE TABLE `lecturer` ( `lecturer_id` int(25) NOT NULL auto_increment, `username` varchar(25) NOT NULL default '', `password` varchar(100) NOT NULL default '', `email_address` varchar(250) NOT NULL default '', PRIMARY KEY (`lecturer_id`) ) TYPE=MyISAM COMMENT='Lecturer Users' AUTO_INCREMENT=4 ; -- -- Dumping data for table `lecturer` -- INSERT INTO `lecturer` VALUES (1, 'lect1', 'dsfsafsgsgsgre4534536546yy5454gh', 'azziman1@hotmail.com'); INSERT INTO `lecturer` VALUES (2, 'lect2', 'dfhsky76764krhg43br43r43y88703hn', 'azziman2@hotmail.com'); [/code] oki thats the database, and yup your solution does work :D