Processing SQL response from multi-dimentional array

Question

Each row of SQL request returns multi-dimentional array with only 1 element "active" now when I do this it outputs even part of array that is "0" as well

for ($i = 0; $i < count($sql_response); $i++) {
    foreach ($sql_response[$i] as $key => $value) {
        if ($key == "active"){
            echo "<br>".$key." - ".$value;
        };
    };
};

If I use === in IF it works, why it does not work with == it seems like i never had this problem with single denominational arrays.

Which programming language is this? It sure doesn't look like SQL. — hmakholm left over Monica
– hmakholm left over Monica, Commented Aug 12, 2011 at 0:37

rid · Accepted Answer · 2011-08-12 00:47:33Z

1

If $sql_response contains something like:

array(
    0 => "value",
    "active" => "value"
)

then the foreach statement will go through both elements, first assigning 0 to $key, then assigning "active" to key.

$key == "active" will return true when $key is 0, because:

it compares 0 == "active"
which casts "active" to integer so it can be compared with 0
which results in 0 == 0
which is true

If you're using the mysql_* or mysqli_* functions to obtain $sql_response, then to prevent adding the numeric keys to the result array, use mysql_fetch_assoc or mysqli_fetch_assoc instead of their *_fetch_array counterparts.

edited Aug 12, 2011 at 0:47

answered Aug 12, 2011 at 0:33

rid

64k31 gold badges159 silver badges201 bronze badges

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

1 Comment

Shackrock Over a year ago

nice... I never know that it would cast a string of letters to a number in this case... this is good to learn.

Collectives™ on Stack Overflow

Processing SQL response from multi-dimentional array

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