{\r
//TODO: check if tables are the same and return a constant for that\r
//echo '!!! ' . $tableA . ' needs ' . $nameB . ' : ' . $tableB . ' needs ' . $nameA . ' !!!<br />';\r
- \r
+ $dbName = $db->query('select database()')->fetchColumn();\r
if($tableA === $tableB)\r
{\r
return self::REFERENCE_SELF;\r
\r
// first look in table A for a reference to B\r
$statement = $db->prepare(sprintf(\r
- 'SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`="divinelegy" AND `TABLE_NAME`="%s"',\r
+ 'SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`="%s" AND `TABLE_NAME`="%s"',\r
+ $dbName,\r
$tableA));\r
\r
$statement->execute();\r
\r
// now look in table b for a reference to a\r
$statement = $db->prepare(sprintf(\r
- 'SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`="divinelegy" AND `TABLE_NAME`="%s"',\r
+ 'SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`="%s" AND `TABLE_NAME`="%s"',\r
+ $dbName,\r
$tableB));\r
\r
$statement->execute();\r