perl foreach array result from a database

Question

I have some select result from database(like on image).

I need do foreach cycle for id

It's must looks like this

foreach () {
   if ($status==1) {
      if ($process_id ~~ @some_array) {
    #do something
   }
}

How do for each cycle? As I understand I need to get a result from a base in hash form $ref = $sth->fetchrow_hashref, but I never worked with him, and my attempts were unsuccessful. Help me please.

Answer 1

Is fetchrow_array what you need?

while (my ($id, $status, $process_id, $error_count) = $sth->fetchrow_array) {
    if (1 == $status and grep $_ == $process_id, @some_array) {
        # do something
    }
}