Hi,

I need to find common elements between two arrays. My code is:

$sql="SELECT DISTINCT fk_paytbl_discounts_discountid as discountid from paytbl_discounts_students WHERE fk_vtiger_cf_601='".$categoryid."'";
$discountstudentinfo=$objdb->customQuery($sql,false);

$sql1="SELECT DISTINCT fk_paytbl_discounts_discountid as discountid from paytbl_discounts_variants WHERE fk_vtiger_products_productid='".$variantid."'";
$discountvariantinfo=$objdb->customQuery($sql1,false);

$commondiscount=array_intersect($discountvariantinfo,$discountstudentinfo);

First array

Array
(
    [0] => Array
        (
            [discountid] => 2
        )

    [1] => Array
        (
            [discountid] => 8
        )

    [2] => Array
        (
            [discountid] => 5
        )

    [3] => Array
        (
            [discountid] => 4
        )

)

Second array

Array
(
    [0] => Array
        (
            [discountid] => 1
        )

    [1] => Array
        (
            [discountid] => 5
        )

)

Common array

Array
(
    [0] => Array
        (
            [discountid] => 1
        )

    [1] => Array
        (
            [discountid] => 5
        )

)

Common array should have only discountid 5 but its showing 1 also.

Please help me on this

Thanks