A8EBm0uv

1CREATE TABLE IF NOT EXISTS `BB_Orders`(
2    `row_id` INT PRIMARY KEY AUTO_INCREMENT,
3    `order_id` VARCHAR(255) NOT NULL DEFAULT '',
4)
5INSERT INTO `BB_Orders`(`row_id`, `order_id`) VALUES(1, '190061603-A')
6INSERT INTO `BB_Orders`(`row_id`, `order_id`) VALUES(2, '190604470-A')
7INSERT INTO `BB_Orders`(`row_id`, `order_id`) VALUES(3, '191206232-A')
8INSERT INTO `BB_Orders`(`row_id`, `order_id`) VALUES(4, '191269277-A')
9	
10function ROWExists($Con, $TableName, $Condition){
11    $RowID=0;
12    $SelectStatement = "SELECT `row_id` FROM `".$TableName."`  WHERE ";
13    foreach($Condition as $CKey=>$CValue){
14        $SelectStatement.="TRIM(`".$CKey."`)=TRIM('".$CValue."') AND ";
15    }
16    $SelectStatement=rtrim($SelectStatement, ' AND ');
17    $SelectStatement.=" LIMIT 1;";
18    echo 'SELECT STATEMENT: '.$SelectStatement.PHP_EOL;
19    echo $SelectStatement.PHP_EOL;
20    $Resultset=mysqli_query($Con, $SelectStatement);
21    if(!empty($Resultset)){
22        if($Resultset->num_rows){
23            while($Result=mysqli_fetch_assoc($Resultset)){
24                if(!empty($Result)){
25                    $RowID=$Result['row_id'];                       
26                }
27            }
28        }   
29    }
30    return $RowID;
31}
32	
33$RowID=ROWExists($Con, 'BB_Orders', array('order_id'=>'190061603-A'));
34//returns the 'row_id' correct
35$RowID=ROWExists($Con, 'BB_Orders', array('order_id'=>'190061603-Z'));
36//returns the 'row_id' incorrect, this should have been 0, but not