formatting if

[ngreenwood6]

I have a statement that i am trying to figure out how to write out. I want it to check that the username isn't in the database ($username > 0) and that it isnt the same as it is now (!= $oldusername) . This is what I have come up with.

 

if ($username > 0 && $username != $oldusername)
{
do this
}

 

Is that correct because it is not going past that point if the username is the same.

[Jabop]

Looks good

[xstevey_bx]

Have you ran a mysql query to try and detect the username from the database?

 

$query = "SELECT * FROM users WHERE username='$username'";
$result = mysql_query($query);
$num = mysql_num_rows($result);

 

Then try If ($num > 0 && .....

[.josh]

loose example:

 

$currentusername = "Johnny";
$newusername = $_POST['newusername'];
$sql = "select username from table where username = '$newusername'";
$result = mysql_query($sql);
$found = mysql_num_rows($result);
if (($found > 0) && ($newusername != $currentusername)) {
 // good to go, do something
} else {
 // already exists are is same as old, do something
}

[ngreenwood6]

crayon violent thanks for the example. However, i am trying to allow the user to update their profile. the problem that I am running into is that I can check the database for the email, but if the user decides to keep it the same it gives them the error that email is already there. I want it to not check the database if they keep it the same. How would i go about doing that?

[ngreenwood6]

Can anyone help me out with this it would be very helpful for future coding?

[.josh]

what are you wanting help with? If you don't want it to check the database if the user posts the same thing, then just check if it's the same thing and not query the database if it's the same as the current.

 

if ($oldusername != $newusername) {

  // query database

}

 

I mean, is that what you're asking, or something else?

[tmallen]

Sounds simple enough. If a user is changing their info, obviously you don't throw an error when the new email is the same as the old one, only if it's the same as another user's. A new user would perform the same check, except there'd be no need to see if their new email is the same as a former address, as they're a new user.