Posted by Jim Michaels on 02/12/06 06:45

"noone" <noone@nowhere.com> wrote in message
news:gyeFf.22252$Jd.8308@newssvr25.news.prodigy.net...
> Mike wrote:
>> I am having a problem getting AND to work. I have a MySQL database field
>> defined as varbinary(8) with X00 in it. Then I have define statements
>> with X01 in it.
>>
>> define('CERTACCESS_MEDALS', x01);

php syntax for hex is 0x01 just as in C/C++.

>>
>> Then I run the data through a function
>>
>> function SecurityLevel_Check($security_byte, $securitylevel_bit) {
>> //AND = 1 IF BOTH are 1
>> return $security_byte And $securitylevel_bit; }

use & instead of and for bitwise operations. echo those values you are
comparing. maybe one of them is a hex string instead of an integer?

>>
>> if(SecurityLevel_Check($recordSet_cert->fields['certcode_access'],
>> CERTACCESS_MEDAL) == 1) {
>>
>>
>> No matter what the values are it always returns a 1. I've looked and
>> looked at the docs and cannot figure out what I am doing wrong. I tried
>> AND and & and both produce different but wrong results.
>>
>> PLEASE throw me a bone of a hint at what I am doing wrong.
>>
>> Thanks.
>>
>> Mike
>>
>>
>
> Take a look at the PACK/UNPACK functions in PHP to unpack and convert the
> data to a number and do the comparison.
>
> http://us2.php.net/manual/en/function.pack.php
> http://us2.php.net/manual/en/function.unpack.php
>
> M.

[Back to original message]