Easy php signup form

i have create very simple sign up form and 90% of my codes are work fine but after users signup in form then can't login with username and password on login form . my sql save username and password fine in phpmyadmin at localhost too .

my sql query : 

create database mycontacts;

use mycontacts;

create table contacts(
id int(11) auto_increment PRIMARY KEY,
full_name varchar(200),
password varchar(50),
repassword text
);

Code (markup):

please check my codes and fix it if you can

 

can you post your code?

 

Need to see the PHP code which is handling the login and registration in order to determine the problem.

 

There is probably an error in connecting to the DB when you log in if it is being added when you sign up.
After your query to check if the username / password are in the database, which probably looks something like:

$result = mysql_query("SELECT * FROM members WHERE username='$username' AND password='$password'");

PHP:

add "or die(mysql_error());" so it looks like

$result = mysql_query("SELECT * FROM members WHERE username='$username' AND password='$password'") or die(mysql_error());

PHP:

This way it will tell you if there is an error.

Goodluck!

 

wow thanks for the info !!!, this is what I looking for...