在数组中调用特定列

Question

I have some array like this
When I use code like this :

I got this error : Notice: Undefined index: users_id in D:\xampp\htdocs\home\database\index.php on line 21

I want to call specific columns like : users_id , users_username ,etc.

If I use :

var_dump ($rowset);

I got :

Array ( [0] => Array ( [users_id] => 1 [users_username] => admin [users_password] => admin

My Code :

$rowset = array();
    while ($row = $sql->fetch(PDO::FETCH_ASSOC)){  `enter code here`
        $rowset[] = $row;
    }
        echo $rowset["users_id"];// Line 21

Thanks

Answer 1

Once try like this,

foreach($rowset as $k => $v){
 echo $rowset[$k]["users_id"];
}