niente provato anche così:
Codice PHP:
$QueryProv=mysql_query("Select *,'db1' as namedatabase from $db1.it_insights as database Where db1.Ident='$idart' UNION Select *,'db2' as namedatabase from $db2.it_news as db2 Where db2.Ident='$idart'") or die (mysql_error()." erroe ricerca database");
$RecProv=mysql_fetch_array($QueryProv);
echo $RecProv["namedatabase"];
mi da questo errore:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database Where db1.Ident='NWS3631579267' UNION Select *,'db2' as namedatabase fr' at line 1