it's a foreign key?

[eluser]zizzo[/eluser]
if i try your query with myphpadmin i obtain a correct result (MUL or PRI), but when i use, in my controller, this:

Code:

$query="SELECT column_key FROM information_schema.columns
WHERE table_schema='sea' AND table_name= ? AND column_name= ?";

$foreign=$this->ci->db->query($query, array($this->table, $field_name));

in $foreign i have "Object id #15"

mmm why?

thanks