Anonymous

$query = "SELECT " .            "A.NAME as NAME, " .            "A.PRESET_FLAG as PRESET_FLAG, " .            "A.SINGLE_OPTION as SINGLE_OPTION, " .            "A.ATTRIBUTE_ID as ATTRIBUTE_ID, " .             "A.PRIMARY_FLAG as PRIMARY, " .            "A.ALLOW_NOTE_FLAG as ALLOW_NOTE, " .            "A.PARENT_ATTRIBUTE_ID as PARENT_ATTRIBUTE_ID, " .            "A.PARENT_ATTRIBUTEVALUE_ID as PARENT_ATTRIBUTEVALUE_ID, " .             "A.HASSUBATTRIBUTES_FLAG as HASSUBATTRIBUTES, " .            "A.ATTRIBUTETYPE_ID as ATTRIBUTETYPE_ID, " .            "AT.NAME as TYPE_NAME " .         "FROM " .            "$db_schema.d2l_attribute A, " .            "$db_schema.d2l_attributetype AT " .         "WHERE A.active_flag = 1 " .            "AND A.defaultforcreate_flag = 1 " .            "AND A.defaultforfilecreate_flag = 0 " .            "AND AT.attributetype_id = A.attributetype_id " .             "AND A.attribute_id IN ($page_attr_ids) " .             "ORDER BY A.rank ASC";