From:             [EMAIL PROTECTED]
Operating system: any
PHP version:      4.1.1
PHP Bug Type:     MySQL related
Bug description:  AND operation errors on datas from MySQL Table

Hello
Can I submit a strange problem PHP / MySQL ?
>From a very simple table, 1 key ( BYTE ), 2 vars ( INTEGER )
I initialise two records whith some values.
I read the first var from first record and second var from second record.
I do the AND ( & ) functiun on the two vars and I get a wrong result.
I join my test script to my request.
Please send problem analysis to [EMAIL PROTECTED]
Best regards.

<html>

<head>
<title>Functiun AND Check</title>
</head>

<?php
// Data Base Open.
    $dbcnx = mysql_connect("localhost");
    if (!$dbcnx)
    {  echo( "<P>No access to Data Base Server.</P>" );
       exit();
    }
    if (! @mysql_select_db("BaseTest") )
    {  echo( "<P>No access to Data Base.</P>" );
       exit();
    }
// Table Création.
    $sql = "CREATE TABLE TEST (
           ".     " Num TINYINT UNSIGNED not null AUTO_INCREMENT,
           ".     " V1 INT (10) UNSIGNED not null,
           ".     " V2 INT (10) UNSIGNED not null,
           ".     " PRIMARY KEY (Num),
           ".     " UNIQUE (Num))
           ".     " comment = 'Table de Test.';"; 
    $crt = mysql_query($sql);
// First record create.
    $x = 0Xffffffff;
    $sql = "INSERT INTO TEST SET
            ".   " V1='$x';";
    $ce = mysql_query($sql);
// Second record create.
    $x = 0X0f0f0f0f; 
    $sql = "INSERT INTO TEST SET
            ".   " V2='$x';";
    $ce = mysql_query($sql);
// Vars initialisation .
    $a = 0;
    $b = 0;
// First record Read.
    $rt = MYSQL_QUERY("SELECT V1 FROM TEST WHERE (Num = 1)") or
die("Erreur No: ".mysql_error());
    $ct = mysql_fetch_array($rt);
    if ($ct)
    {   $a = $ct[V1];
    }
    mysql_free_result ($rt);
// Second record read.
    $rt = MYSQL_QUERY("SELECT V2 FROM TEST WHERE (Num = 2)") or
die("Erreur No: ".mysql_error());
    $ct = mysql_fetch_array($rt);
    if ($ct)
    {   $b = $ct[V2];
    }
    mysql_free_result ($rt);
// AND functiun on results and display.    
    $x = $a & $b;
    echo ("Var A = ".DecBin($a)."<br>");
    echo ("Var B = ".DecBin($b)."<br>");   
    echo ("AND Result = ".DecBin($x)."<br>");
// Correct display for vars.
// Waiting AND Result = 1111000011110000111100001111
// I get   AND Result = 1100010101010011001
// Where the error is?.
?>
</body>
</html>

-- 
Edit bug report at http://bugs.php.net/?id=15565&edit=1
-- 
Fixed in CVS:        http://bugs.php.net/fix.php?id=15565&r=fixedcvs
Fixed in release:    http://bugs.php.net/fix.php?id=15565&r=alreadyfixed
Need backtrace:      http://bugs.php.net/fix.php?id=15565&r=needtrace
Try newer version:   http://bugs.php.net/fix.php?id=15565&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=15565&r=support
Expected behavior:   http://bugs.php.net/fix.php?id=15565&r=notwrong
Not enough info:     http://bugs.php.net/fix.php?id=15565&r=notenoughinfo
Submitted twice:     http://bugs.php.net/fix.php?id=15565&r=submittedtwice

Reply via email to