CODEWITHSUNDEEP
mysqlmacosphpmyadminmamp
vlad halmer
vlad halmer

Reputation: 1301

phpmyadmin choose field to display missing in relation view

I am using phpmyadmin 4.0.5. I want to show column value instead of its id while adding a row in a table where that column acts as foreign key.

Now as per https://serverfault.com/questions/365997/how-to-enable-displaying-choose-column-to-display-in-phpmyadmin , I have added 

   $cfg['Servers'][$i]['nrollin'];
   $cfg['Servers'][$i]['coaching_field'];

in config.inc.php but I see no "choose field to display" option in relation view of coaching_field table. "nrollin" is my database.

Can anyone please tell me what is the possible mistake I am making?

Upvotes: 3

Views: 3998

Answers (2)

tony gil
tony gil

Reputation: 9554

enable table_info in config.inc.php file

$cfg['Servers'][$i]['table_info'] = 'pma_table_info';

Upvotes: 1

Marc Delisle
Marc Delisle

Reputation: 9012

These settings you try are not correct. First, you must install the phpMyAdmin configuration storage (http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage), then you'll be able to go on Structure of this table, click Relation view and "Choose column to display". Afterwards, you'll be able to see either a foreign key dropdown or link, when adding a row.

Upvotes: 5

Related Questions