Using while..list with DB::getInstance()->nextRow()

[MrBaseball34]

I'm having trouble doing this:

   $niinssql = "SELECT description, nsn, niins_id FROM `niins` WHERE PARTNO = '".$partno."'";
   $niinsresult = Db::getInstance()->Execute($niinssql);
   if($niinsresult) {
   while (list($description, $nsn, $niins_id)=DB::getInstance()->nextRow($niinsresult))
       /*********************************************************
       // do something with $description, $nsn, $niins_id values
       /*********************************************************
     } // while (list($description, $nsn, $niins_id)=DB::getInstance()->getRow($niinsresult))
   } // if($niinsresult)

I'm getting all blank values even though I know there is at least one row.
Can this be done or not?

[rocky]

I can get the next row to work, but not using the list syntax for some reason. Try using the following instead:

$niinssql = "SELECT description, nsn, niins_id FROM `niins` WHERE PARTNO = '".$partno."'";
   $niinsresult = Db::getInstance()->Execute($niinssql);
   if($niinsresult) {
   while ($row=Db::getInstance()->nextRow($niinsresult))
       /*********************************************************
       // do something with $row['description'], $row['nsn'], $row['niins_id'] values
       /*********************************************************
     } // while ($row=DB::getInstance()->getRow($niinsresult))
   } // if($niinsresult)

[MrBaseball34]

I went with the foreach structure