=> array( * 'type' => , * 'value' => , * 'exact' => , * ) * ) * where options should include the id and type for that table to correctly * group a set of records together where the only difference are the value and rank * @return the maximum rank * */ function get_max_chado_rank($tablename, $where_options) { $where = array(); //generate the where clause from supplied options // the key is the column name $args = array(); $i = 0; $sql = " SELECT max(rank) as max_rank, count(rank) as count FROM {:table} WHERE 1=1 "; $args[":table"] = $tablename; foreach ($where_options as $key => $val_array) { if (preg_match('/INT/', $val_array['type'])) { $sql .= " AND $key = :$key$i "; $args[":$key$i"] = $val_array['value']; } else { if ($val_array['exact']) { $operator = '='; } else { $operator = '~'; } $sql .= " AND $key $operator :$key$i "; $args[":$key$i"] = $val_array['value']; } $i++; } $result = chado_query($sql, $tablename, $args)->fetchObject(); //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; } }