Hello,

Iv done everything i can think but it's still not working,

The Prob is when someone sign-up it says "Your account has been created successfully!" and and then when you try to login it keeps saying "Name and password not found or not matched"


Have a look www.pro-gamer.me/test

your login logic is wrong

Sorry But im new to this stuff what part shall i edit?

Here ill upload the Login.PHP & Register.PHP

for you
http://rapidshare.com/files/40856574...gister_php.rar

This is not a PHP forum.

I think this thread should be moved.

Sorry But Im new to this stuff, and i need help with the database read the title

You need help with the PHP interacting with your database, not the database itself. The PHP guys can probably explain the difference a bit more eloquently than I can.

Moving to the PHP forum.

Here is some of the table structer for the database.
-- Table structure for table `grpgusers`
--

CREATE TABLE `grpgusers` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(75) NOT NULL default '0',
`password` varchar(75) NOT NULL default '0',
`exp` int(30) NOT NULL default '0',
`money` int(30) NOT NULL default '1000',
`bank` int(30) NOT NULL default '0',
`whichbank` int(2) NOT NULL default '0',
`hp` int(10) NOT NULL default '50',
`energy` int(10) NOT NULL default '10',
`nerve` int(10) NOT NULL default '5',
`workexp` int(10) NOT NULL default '0',
`strength` int(10) NOT NULL default '10',
`defense` int(10) NOT NULL default '10',
`speed` int(10) NOT NULL default '10',
`battlewon` int(10) NOT NULL default '0',
`battlelost` int(10) NOT NULL default '0',
`battlemoney` int(20) NOT NULL default '0',
`crimesucceeded` int(10) NOT NULL default '0',
`crimefailed` int(10) NOT NULL default '0',
`crimemoney` int(20) NOT NULL default '0',
`points` bigint(20) NOT NULL default '0',
`rmdays` tinyint(5) NOT NULL default '0',
`signuptime` int(20) NOT NULL default '0',
`lastactive` int(20) NOT NULL default '0',
`awake` int(5) NOT NULL default '100',
`email` varchar(75) NOT NULL default '',
`jail` int(1) NOT NULL default '0',
`hospital` int(1) NOT NULL default '0',
`hwho` varchar(30) NOT NULL,
`hwhen` varchar(30) NOT NULL,
`hhow` varchar(30) NOT NULL,
`house` int(3) NOT NULL default '0',
`gang` int(10) NOT NULL default '0',
`quote` text NOT NULL,
`avatar` varchar(50) NOT NULL,
`city` int(3) NOT NULL default '1',
`admin` int(1) NOT NULL default '0',
`searchdowntown` int(3) NOT NULL default '100',
`job` int(5) NOT NULL,
`ip` int(20) NOT NULL,
`eqweapon` int(20) NOT NULL,
`eqarmor` int(20) NOT NULL,
`potseeds` int(20) NOT NULL,
`marijuana` int(20) NOT NULL,
`cocaine` int(20) NOT NULL,
`style` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ;

-- --------------------------------------------------------