Mine

  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;  }