[cmmourik]

For my master thesis I am writing a php file that converts a mysql
database to XML. But it is important that I can recognize foreign
keys. I know I can use 'mysql_field_flags' to find primary keys but
don't know if there is a way to recognize foreign keys! Any
suggestions???

Plz help!

[moronovich]

first step for foreign key?

Code:

mysql> show create table table_name;
mysql> show keys from table_name;

after testing in mysql console you can run the mysql_query function and get the appropriate result.