function tripal_feature_load_references

1.x tripal_feature.module tripal_feature_load_references($feature_id)

Related topics

Feature Module
Provides functions for managing chado features including creating details pages for each feature
1 call to tripal_feature_load_references()
tripal_feature_edit_ALL_db_references_form in tripal_feature/includes/tripal_feature-db_references.inc
Implements Hook_form() Handles adding of DB References to Features

File

tripal_feature/tripal_feature.module, line 1053
@todo Add file header description

Code

function tripal_feature_load_references($feature_id) {

  $sql = "SELECT F.uniquename,F.Feature_id,DBX.accession,DB.description as dbdesc, " .
    "   DB.db_id, DB.name as db_name, DB.urlprefix,DBX.dbxref_id " .
    "FROM {feature} F " .
    "  INNER JOIN {feature_dbxref} FDBX on F.feature_id = FDBX.feature_id " .
    "  INNER JOIN {dbxref} DBX on DBX.dbxref_id = FDBX.dbxref_id " .
    "  INNER JOIN {db} on DB.db_id = DBX.db_id " .
    "WHERE F.feature_id = %d " .
    "ORDER BY DB.name ";
  $results = chado_query($sql, $feature_id);
  $references = array();
  $i = 0;
  while ($accession = db_fetch_object($results)) {
    $references[$i++] = $accession;
  }
  return $references;
}