public static function get_meta_relations_1($metadata_id, $metadata_id1) { global $dbconnection; $query = "select \n metadata_relation.metadata_field_id1,\n metadata_relation.metadata_field_id2\n from \n metadata_relation, \n metadata_table as metadata_table1, \n metadata_field as metadata_field1, \n metadata_table as metadata_table2, \n metadata_field as metadata_field2\n where \n metadata_relation.metadata_field_id1 = metadata_field1.id and \n metadata_field1.metadata_table_id = metadata_table1.id and \n metadata_table1.metadata_id = {$metadata_id} and \n metadata_relation.metadata_field_id2 = metadata_field2.id and \n metadata_field2.metadata_table_id = metadata_table2.id and \n metadata_table2.metadata_id = {$metadata_id1}\n "; $result = $dbconnection->do_query_meta_response($query); $fields = array(); while ($myrow = mysql_fetch_array($result)) { $fields[] = array($myrow["metadata_field_id1"], $myrow["metadata_field_id2"]); } $relations = array(); foreach ($fields as $field) { $relations[] = query::get_meta_relations_2($field[0]) . " = " . query::get_meta_relations_2($field[1]); } return $relations; }