<PRE>
<?php
  $glob_DB_name = 'zu';
  $link = mysql_connect('localhost' , 'root' , '*****');
  mysql_select_db($glob_DB_name, $link);
  
  
  if ((!$rset = mysql_query ("SHOW CREATE TABLE `tableZu`" , $link))) die (mysql_error($link));
  $row = mysql_fetch_array($rset);
  
  $sql = $row [ 1 ];
  
  $lines = explode ("\n"   , $sql);
  foreach ($lines as $l){
  	if (strpos($l , 'FOREIGN KEY') !== false){
  		$p = strpos($l , 'FOREIGN KEY');
  		$l = substr($l , $p + (strlen('FOREIGN KEY')));
  		$l = trim ($l);
  		$p = strpos($l , ' ');
  		
  		$slave_field =  trim (substr($l ,  0  , $p) , "('`\"[{}]`') ");
  		print ("slave_field = $slave_field\n");
  		
  		$p = strpos($l , 'REFERENCES');
  		$l = trim(substr($l , $p + (strlen('REFERENCES'))));
  		
  		
  		$p = strpos($l , ' ');
  		$master_table = trim(substr($l ,  0  ,  $p), "('`\"[{}]`') ");
  		print (" master_table =$master_table\n");
		$l = substr($l , $p +  1 );
  		$p = strpos($l , ')');
  		$master_field= trim(substr($l ,  0  ,  $p), "('`\"[{}]`') ");
  		print (" master_field =$master_field\n");
  		
  	}
  }

?>
</PRE>