[RESOLVED] compare variable to array

[Springles]

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/Q_23471118.html

Hello guys
i cannot find answer at the simple question how to compare variable to array.
for example i have some data from database
"one", "two", "three", "four", "five".
and i need to do:

if ($some_var = "two" and "three")
{
execute some code
}

[bradgrafelman]

Are you asking how to check if a value is in an array? If so, see: [man]in_array/man.

[Springles]

It wont work.

$sql = "SELECT user_name FROM `data_manager`.`user_accounts`;";
$check_name = in_array($register_user_name, $sql);

if ($register_user_name != $check_name){
	if ($register_password == $confirm_password) {
		DOSOMETHING
	} else {
		print "The password you entered does not match, please retry.";
	}
} else {
	print "This username is already being used !";
}

[bradgrafelman]

That's because the string "SELECT user_name FROM data_manager.user_accounts;" is not an array, which is what [man]in_array/man expects as its second parameter.

[Springles]

So what should I do ? code example plese.

[dagon]

Springles;10976808 wrote:

So what should I do ? code example plese.

run the actual query return the data, check it

OR....

add a WHERE clause to the query to check the user-name