function gethwcode($hostid)
  {

      $query = "SELECT id FROM tblcustomfields WHERE fieldname='Hardware Code'";
      $result = mysql_query($query) or die(mysql_error());
      
      while ($data = mysql_fetch_array($result)) {

	      $query2 = "SELECT value FROM tblcustomfieldsvalues WHERE fieldid='" . $data['id'] . "' AND relid='" . $hostid. "'";
	      $result2 = mysql_query($query2);
	      
	      $data2 = mysql_fetch_array( $result2 );
	      $hwcode = $data2['value'];
      }

	return $hwcode;

  }