comparing a string to a Mysql db result

[diezy]

i have an if state have is comparing a result from a database and submitted string from a form.

when i print them out they both print the same result
123456 (db result)

123456 (submitted form result)

however try to compare them to see if they are equal in a if statement, it comes out false.
<code>
if($obj_db->fetch_array('password')== $str_login_password)
{
//code
}
</code>

when i use the is_string() function on database result is says its not a string....but the submitted form result is?

now just to clearify some things....my field i have querying/retrieving is a varchar field.

anyone have any suggest to get around this so i can check for the same value (cause i know they are...just the variable types are not)

 

[Meekos]

Try using the trim function

if($obj_db->fetch_array('password') == trim($str_login_password)) {
//code
}

 

[Olavxxx]

This might be because 123456 is really an integer.

Try this:

if(trim("" . $obj_db->fetch_array('password') . "") == trim($str_login_password))

ps. this is as dirty as it gets!

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster