Check if $key 0: if drop

Hej Eksperter.

Jeg skal hente en masse værdier fra databasen, og herefter liste dem. Dog vil jeg gerne have at de ikke blive listet hvis de er '0'? altså hvis kolonnen indeholder et tal andet end 0, list ikke?

Nogen der har forslag til hvordan jeg kan gøre dette?

På forhånd tak, og god weekend :-)


public function get_records( $column, $prop="" ) {

  $sql = "SELECT " . $column . " FROM " . $this->table_name . " " . $prop;
  $res = mysql_query( $sql ) or die( mysql_error() . " - " . $sql );
       
  $rows = array();   
  while( $row = mysql_fetch_array( $res ) ) {
           
    $rows[] = $row;
  }
       
  return $rows;

   
}


public function get_user_belongings( $user_id ) {
   
  $user_belongings = $this->get_records( "supply1, supply2, supply3, supply4, supply5, supply6, supply7, supply8", "WHERE id = '" . $user_id . "'" );
       
  foreach( $user_belongings as $key => $resource ) {
  }

  //make list
  $resources = "<div class=\"resources\"><img src=\"/images/icons/1.png\" class=\"icon\" title=\"Hat\">".$resource["supply8"]."</div>";
  $resources .= "<div class=\"resources\"><img src=\"/images/icons/2.png\" class=\"icon\" title=\"Briller\">".$resource["supply7"]."</div>";   
  $resources .= "<div class=\"resources\"><img src=\"/images/icons/3.png\" class=\"icon\" title=\"Sko\">".$resource["supply6"]."</div>";
  $resources .= "<div class=\"resources\"><img src=\"/images/icons/4.png\" class=\"icon\" title=\"T-shirt\">".$resource["supply5"]."</div>";
  $resources .= "<div class=\"resources\"><img src=\"/images/icons/5.png\" class=\"icon\" title=\"Jeans\">".$resource["supply4"]."</div>";
  $resources .= "<div class=\"resources\"><img src=\"/images/icons/6.png\" class=\"icon\" title=\"Cap\">".$resource["supply3"]."</div>";
  $resources .= "<div class=\"resources\"><img src=\"/images/icons/7.png\" class=\"icon\" title=\"Tilbehør\">".$resource["supply2"]."</div>";
  $resources .= "<div class=\"resources\"><img src=\"/images/icons/8.png\" class=\"icon\" title=\"Ekstra\">".$resource["supply1"]."</div>";

  return $resources;
   
}