array and mysql result problem 1

[electricphp]

how come this works:

$existing_users=array('roshan','mike','jason');

$user_name="roshan";
//checking weather user exists or not in $existing_users array
if (in_array($user_name, $existing_users))
{
	//user name is not availble
	echo "no";
} 
else
{
	//user name is available
	echo "yes";
}

but this doesn't

$existing_users=array();
$query = "SELECT username FROM users";
$result = mysql_query($query);

while($row=mysql_fetch_row($result))
{
      $existing_users[] = $row;
}

mysql_free_result($result);

$user_name="roshan";
//checking weather user exists or not in $existing_users array
if (in_array($user_name, $existing_users))
{
	//user name is not availble
	echo "no";
} 
else
{
	//user name is available
	echo "yes";
}

even though roshan is inside the table named users

 

[jpadie]

delete these lines

while($row=mysql_fetch_row($result))
{
      $existing_users[] = $row;
}

and substitute with

while($row=mysql_fetch_assoc($result)){
      $existing_users[] = $row['username'];
}

note that your code is case sensitive. you may wish to cast the case to upper/lower case before testing it.

e.g.

while($row=mysql_fetch_assoc($result)){
      $existing_users[] = strtoupper($row['username']);
}