PHP can anyone help me.
Message: Please change your phpMyAdmin configuration to set up our MySQL database to support the relational database tools as prescribed in the manual. I have enclosed an excerpt from the phpMyAdmin...
$cfg[\'Servers\'][$i][\'relation\'] string
Since release 2.2.4 you can describe, in a special \'relation\' table, which field is a key in another table (a foreign key). phpMyAdmin currently uses this to
make clickable, when you browse the master table, the data values that point to the foreign table;
display in an optional tooltip the \"display field\" when browsing the master table, if you move the mouse to a column containing a foreign key (use also the \'table_info\' table);
display links on the table properties page, to check referential integrity (display missing foreign keys) for each described key;
in query-by-example, create automatic joins (see an example in the FAQ, section \"Using phpMyAdmin\");
enable you to get a PDF schema of your database (also uses the table_coords table).
The keys can be numeric or character.
To allow the usage of this functionality the superuser has to:
set up \"pmadb\" as described above
within this database create a table following this scheme:
CREATE TABLE `PMA_relation` (
`master_db` varchar(64) NOT NULL default \'\',
`master_table` varchar(64) NOT NULL default \'\',
`master_field` varchar(64) NOT NULL default \'\',
`foreign_db` varchar(64) NOT NULL default \'\',
`foreign_table` varchar(64) NOT NULL default \'\',
`foreign_field` varchar(64) NOT NULL default \'\',
PRIMARY KEY (`master_db`, `master_table`, `master_field`),
KEY foreign_field (foreign_db, foreign_table)
) TYPE=MyISAM COMMENT=\'Relation table\';
put the relation table name in $cfg[\'Servers\'][$i][\'relation\']
now as normal user open phpMyAdmin and for each one of your tables where you want to use this feature, click \"Structure/Relation view/\" and choose foreign fields.
Please note that in the current (2.3.0) version, master_db must be the same as foreign_db. Those fields have been put in future development of the cross-db relations.
If anyone can give me some good helpful advice i would appreciate it.
