PHP in_array is not finding value that is there

Question

I have this code:

$sql_zt = "SELECT
                    inh_pr.extra_bew_zetten AS extra_bew_zetten
                FROM 5_offerte_id AS off
                LEFT JOIN 6_offerte_inh AS off_inh
                ON off_inh.offerte_id = off.id
                LEFT JOIN 3_product_folder AS fld
                ON fld.folder_id = off_inh.folder_id
                LEFT JOIN 0_calculatie_inh_id_geg_lntk_product AS inh_pr
                ON inh_pr.calculatie_inh_id = fld.product_id
                WHERE off.dossier_id = ".$row['id']." AND inh_pr.extra_bew_zetten = 'ja' AND off.offerte_nr = (SELECT MAX(offerte_nr) FROM 5_offerte_id WHERE dossier_id = ".$row['id'].") ";

if(!$res_zt = mysql_query($sql_zt,$con))
{
    include('includes/errors/database_error.php');
}

if(mysql_num_rows($res_zt) > 0)
{
    if(in_array('ja', mysql_fetch_array($res_zt)))
    {
        echo '<img border="0" src="images/icon/zetten.png" title="'.$lang['zetten'].'"> ';
    }
}

This is my output example with the query:

Value 'ja' is not found with in_array. What might be the problem?

Could there be any spaces in the strings in the array which is breaking the comparison? 'ja' != 'ja ' — philreed
– philreed, Commented Sep 28, 2015 at 10:10
Note that AND inh_pr.extra_bew_zetten = 'ja' will render as an INNER JOIN — Strawberry
– Strawberry, Commented Sep 28, 2015 at 10:21

Man Programmer · Accepted Answer · 2015-09-28 10:11:59Z

3

there are more than one record you can use loop for it

while($row = mysql_fetch_array($res_zt)){

if(in_array('ja',$row))
    {
        echo '<img border="0" src="images/icon/zetten.png" title="'.$lang['zetten'].'"> ';
    }
}

answered Sep 28, 2015 at 10:11

Man Programmer

5,3662 gold badges24 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ralph Melhem Over a year ago

Yup, you were testing only the first row mate, you should loop all rows fetched from the db

Collectives™ on Stack Overflow

PHP in_array is not finding value that is there

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related