all set, thanks anyways, figured it out on my own, also was a php problem that was not found untill i perfected the table :) thanks again for dealing with me :p
weird, i check the user data in the database and it seems to be storeing the users but not authenticateing them
http://www.wsupreme.com/members/bin/users.JPG
im confussed now, as if i werent to begin with heh. any help would be great thanks :)
sorry for the confussion, im learning MySQL in 48 hours, i more understand this now. Ok this is the query i got
SQL-query :
CREATE TABLE `mydb`.`members` (
`id` int(5) unsigned NOT NULL auto_increment,
`member_id` varchar(11) NOT NULL default '000…