other_module_api_functions.inc File Reference

Go to the source code of this file.

Functions
	get_max_chado_rank ($tablename, $where_options)

---

Detailed Description

Definition in file other_module_api_functions.inc.

---

Function Documentation

get_max_chado_rank	(	$	tablename,
		$	where_options
	)

Definition at line 29 of file other_module_api_functions.inc.

                                                        {

  $where= array();
  //generate the where clause from supplied options
  // the key is the column name
  foreach ($where_options as $key => $val_array) {
    if (preg_match('/INT/', $val_array['type'])) {
      $where[] = $key . "=" . $val_array['value'];
    }
    else {
      if ($val_array['exact']) {
        $operator='='; }
      else { $operator='~'; }
        $where[] = $key . $operator . "'" . $val_array['value'] . "'";
    }
  }

  $result = db_fetch_object(chado_query(
    "SELECT max(rank) as max_rank, count(rank) as count FROM %s WHERE %s",
    $tablename,
    implode(' AND ', $where)
  ));
  //drupal_set_message("Max Rank Query=SELECT max(rank) as max_rank, count(rank) as count FROM ".$tablename." WHERE ".implode(' AND ',$where));
  if ($result->count > 0) {
    return $result->max_rank;
  }
  else {
    return -1;
  }
}