PHPMyAdmin - Can I view actual field values instead of the foreign keys?

Posted by Callum on Server Fault See other posts from Server Fault or by Callum
Published on 2010-09-14T07:15:54Z Indexed on 2011/01/06 8:55 UTC
Read the original article Hit count: 284

Filed under:

phpmyadmin

I have a database with some MyISAM tables. The tables contain foreign key relationships, but they are not inherently "enforced" (I believe "referential integrity" is the term).

Using PHPMyAdmin, what I'd like to do is be able to view records from the tables but have all foreign keys replaced by whatever value they are representing.

Eg, instead of seeing:

23 | 14 | $6.50

I'd like to see..

Extra Large | Thin Crust | $6.50

($6.50 would be an editable field, the first two fields would not be).

Any helpers? Thanks.

Related posts about phpmyadmin

phpMyAdmin (Ubuntu10.04): How can phpMyAdmin be restarted after /etc/phpmyadmin/config.inc.php file

as seen on Super User - Search for 'Super User'
Hi How can phpMyAdmin(Ubuntu10.04) be restarted after /etc/phpmyadmin/config.inc.php file was changed? thanks >>> More
Phpmyadmin Not Working

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I recently installed phpmyadmin onto ubuntu server 10.04 using sudo apt-get install phpmyadmin The installation went fine and everything was working including phpmyadmin. I then performed a restart of the server and now apache2 starts up but when I navigate to http://192.168.1.72/phpmyadmin/ I… >>> More
Ubuntu phpmyadmin installtio gui problem- dont see my new installed program (phpmyadmin) in program

as seen on Super User - Search for 'Super User'
Ubuntu phpmyadmin installtio gui problem- dont see my new installed program (phpmyadmin) in programs gui list on ubuntu 10.04. I install phpmy admin with Synaptic package manager. Thanks >>> More
Nginx phpmyadmin redirecting to / instead of /phpmyadmin upon login

as seen on Server Fault - Search for 'Server Fault'
I am having issues with my phpmyadmin on my nginx install. When I enter <ServerIP>/phpmyadmin and logs in, I get redirected to <ServerIP>/index.php?<tokenstuff> instead of <ServerIP>/phpmyadmin/index.php?<tokenstuff> Nginx config file: user nginx; worker_processes… >>> More
How to setup phpmyadmin with nginx and access it from http://vps-ip/phpmyadmin

as seen on Server Fault - Search for 'Server Fault'
The phpmyadmin files are located here /usr/share/phpmyadmin/ And I have this server block code that allows me to access phpmyadmin only from http://vps-ip/: server { listen 80; ## listen for ipv4; this line is default and implied #listen [::]:80 default ipv6only=on; ## listen for… >>> More

Developer IT

PHPMyAdmin - Can I view actual field values instead of the foreign keys? - Developer IT

PHPMyAdmin - Can I view actual field values instead of the foreign keys?

phpmyadmin

Related posts about phpmyadmin

phpMyAdmin (Ubuntu10.04): How can phpMyAdmin be restarted after /etc/phpmyadmin/config.inc.php file

Phpmyadmin Not Working

Ubuntu phpmyadmin installtio gui problem- dont see my new installed program (phpmyadmin) in program

Nginx phpmyadmin redirecting to / instead of /phpmyadmin upon login

How to setup phpmyadmin with nginx and access it from http://vps-ip/phpmyadmin

Categories cloud