phpadmin php一样吗,PHP与Phpmyadmin

我有这个代码,我在phpmyadmin上执行,可以100％运行

Create Temporary Table Searches ( id int, dt datetime);

Create Temporary Table Searches1 ( id int, dt datetime, count int);

insert into Searches(id, dt) select a.id, now() from tblSavedSearches a;

insert into Searches1(id, dt, count)

select

b.savedSearchesId,

(select c.dt from tblSavedSearchesDetails c where b.savedSearchesId = c.savedSearchesId order by c.dt desc limit 1) as 'dt',

count(b.savedSearchesId) as 'cnt'

from tblSavedSearchesDetails b

group by b.savedSearchesId;

insert into tblSavedSearchResults(savedSearchId,DtSearched,isEnabled)

select id,now(),0 from Searches where not id in (select savedSearchId from tblSavedSearchResults);

update tblSavedSearchResults

inner join Searches1 on tblSavedSearchResults.savedSearchId = Searches1.id

Set tblSavedSearchResults.DtSearched = Searches1.dt, tblSavedSearchResults.isEnabled = 1;

但是,当我将相同的代码放在php中时,它会产生错误

$dba = DbConnect::CreateDbaInstance();

$query = "";

$query.="Create Temporary Table Searches ( id int, dt datetime); ";

$query.="Create Temporary Table Searches1 ( id int, dt datetime, count int); ";

$query.="insert into Searches(id, dt) select a.id, now() from tblSavedSearches a; ";

$query.="insert into Searches1(id, dt, count) ";

$query.="select ";

$query.=" b.savedSearchesId, ";

$query.=" (select c.dt from tblSavedSearchesDetails c where b.savedSearchesId = c.savedSearchesId order by c.dt desc limit 1) as 'dt', ";

$query.=" count(b.savedSearchesId) as 'cnt' ";

$query.="from tblSavedSearchesDetails b ";

$query.="group by b.savedSearchesId; ";

$query.="insert into tblSavedSearchResults(savedSearchId,DtSearched,isEnabled) ";

$query.="select id,now(),0 from Searches where not id in (select savedSearchId from tblSavedSearchResults); ";

$query.="update tblSavedSearchResults ";

$query.="inner join Searches1 on tblSavedSearchResults.savedSearchId = Searches1.id ";

$query.="Set tblSavedSearchResults.DtSearched = Searches1.dt, tblSavedSearchResults.isEnabled = 1; ";

$dba->DbQuery($query) or die(mysql_error());

我收到以下错误

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 'Create Temporary Table Searches1 ( id int, dt datetime, count int) insert into S' at line 1

如果有人可以帮助我,请…

谢谢