[SOLVED] Basic Check if 'Username" already exists...

[suttercain]

Hi guys, I have

<?php
$usertest = mysql_query("SELECT username FROM merchants WHERE username = '" .mysql_real_escape_string($_POST['username']). "'");
if ($usertest) {
echo $_POST['username']. " is already taken. Please select a different username.";
} else {
//process other code
}
?>

What am I doing wrong. I need to check if the username is already in the database. If it is, the script stops. If not, the code process begins.

 

Thanks.

[AdRock]

what errors are you getting?

[suttercain]

No errors, but no matter what I get that the username already exists in the database, even if it doesn't.

 

SC

[MadTechie]

You need to pull the data

 

<?php
$usertest = mysql_query("SELECT username FROM merchants WHERE username = '" .mysql_real_escape_string($_POST['username']). "'");
$num_rows = mysql_num_rows($usertest);
if ($num_rows >0) {
echo $_POST['username']. " is already taken. Please select a different username.";
} else {
//process other code
}
?>

 

[suttercain]

Doh! Thanks madtechie!

 

It has been a long week.

 

[micmania1]

<?php
$usertest = mysql_query("SELECT username FROM merchants WHERE username = '" .mysql_real_escape_string($_POST['username']). "'");
$user_exist= mysql_num_rows($usertest);
if ($user_exist > 1) {
echo $_POST['username']. " is already taken. Please select a different username.";
            exit(); // Exit the script
} else {
//process other code
}
?>

 

Got there before me lol

 

If you want to quit the script you will need to put "exit();" on line 5 as i've done.