Topic: [SOLVED] Simple MySQL problem

[Perad]

This is to check if the user Alias is already taken. However if the name is in there or not it still returns the error saying it is. What can i change so it only flags up when the user actually isn't in there.

Code: [Select]

$sql="SELECT * FROM blog_members WHERE user_alias='$this->userAlias'";
$result = mysql_query($sql);
if ($result) {
echo " - Error 5005 - This username is taken!";
$this->error[] = 1;
}

[thorpe]

Code: [Select]

<?php

$sql="SELECT * FROM blog_members WHERE user_alias='$this->userAlias'";
$result = mysql_query($sql);
if ($result) {
  if (mysql_num_rows($result)) {
echo " - Error 5005 - This username is taken!";
$this->error[] = 1;
  }
}

?>