Register Details Problem!

obrienkev

Hi all,
I have created a register page where a user registers his/her details in MySQL database. However each time I test in browser I am told the user already exists - no matter what username i enter!! username is the primary key.
This is some of my code:

// check if username is unique
$result = mysql_query("select * from user where username='$username'");
if (!$result)
return 'Could not execute query';
if (mysql_num_rows($result)>0)
return 'That username is taken - go back and choose another one.';

Where have I gone wrong??
Thanks very much.
Kevin.

TTT

this should now make the different but...

if (mysql_num_rows($result) != 0)  {
}

or you have already stored variable as session or other global variable

The_Chancer

Well - if you can only have one username the same...

if (mysql_num_rows($result)==1)
{
return "username taken";
}

Cos you can't have more than one the same....

obrienkev

sorry guys still get the same response when i change to result==1 or when i have result!=0.
Any other suggestions would be greatly appreciated.

The_Chancer

// check if username is unique
$result = mysql_query("select * from user where username='$username'");
//bugcheck
echo "select * from user where username='".$username."'";
echo mysql_num_rows($result);
if (!$result)
return 'Could not execute query';
if (mysql_num_rows($result)>0)
return 'That username is taken - go back and choose another one.';

Echo out what the mysql_num_rows gives you - as well as the query itself - bugcheck...

obrienkev

Cheers for that. I did that and now I get:

select * from user where username=''1That username is taken - go back and choose another one.

What should I do now???
Thanks again for your help!

obrienkev

still stuck! any more ideas would be gretaly appreciated!
Thanks.