php中的mysql多语句(Mysql multi statement in php)

 我不是很擅长说英语，所以我支持谷歌的翻译，谢谢。 
 
 会发生什么事情，我正在使用谷歌地图api，我有一些商店的数据库，数据库是这些的方向，用javascript获取商店和用户的位置之间的距离，我想要的主题按接近程度排序，我所做的是第一页计算所有离开，然后重定向以下格式"pagina.php?data=(ID, DISTANCE),(ID, DISTANCE), ..... " 
 
 然后得到参数 
 
<?php $data = $ _GET['data'] ?>   // and example of "data" -> "(1,1582),(2,3568)," end with comma
 
 我正在尝试使用这个命令“”在phpMYAdmin中工作“” 
 
CREATE TEMPORARY TABLE distancias_temporales (id int(50) NOT NULL, distancia DECIMAL(12,2) NOT NULL DEFAULT 0.00);

INSERT INTO distancias_temporales (id, distancia) VALUES (1, 14.25), (2, 13.34);

SELECT * FROM talleres,distancias_temporales WHERE distancias_temporales.id = talleres.ID ORDER BY distancia ASC;
 
 当然要做动态变化值： 
 
$ data = "(-1, -1)";
if (isset ($ _GET ['data'])) {
$ data = $ _GET ['data']. "(-1, -1)";
}
 
 在第二行： 
 
 "INSERT INTO d (id, distancia) VALUES ".$data.";";
 
 但是mysql根据他告诉我的页面发送了我的错误，代码按我的意愿发送 
 
 但是当我试图放在页面上时它不起作用...... 
 
 任何人都可以帮助我，我认为这个问题将是多重查询 

I'm not very good at speaking English so I'm supporting the translator of google, thanks.
 
What happens is that I'm working with google maps api and I have a database with some shops, the database is the direction of these, that with a javascript get the distance between the store and the location of user, the topic I want to sort by proximity, what I did was a first page which calculates all away and then redirects the following format "pagina.php?data=(ID, DISTANCE),(ID, DISTANCE), ..... "
 
then get the parameter
 
<?php $data = $ _GET['data'] ?>   // and example of "data" -> "(1,1582),(2,3568)," end with comma
 
And I'm trying to use this command "" THAT WORKS IN phpMYAdmin ""
 
CREATE TEMPORARY TABLE distancias_temporales (id int(50) NOT NULL, distancia DECIMAL(12,2) NOT NULL DEFAULT 0.00);

INSERT INTO distancias_temporales (id, distancia) VALUES (1, 14.25), (2, 13.34);

SELECT * FROM talleres,distancias_temporales WHERE distancias_temporales.id = talleres.ID ORDER BY distancia ASC;
 
Of course to do dynamic change values​​:
 
$ data = "(-1, -1)";
if (isset ($ _GET ['data'])) {
$ data = $ _GET ['data']. "(-1, -1)";
}
 
and in the second line:
 
 "INSERT INTO d (id, distancia) VALUES ".$data.";";
 
but mysql send my an error according to what he tells me the page, the code is sent as I want
 
But it does not work when I try to put on the page ...
 
anyone can help me, the problem I think would be the multi query

原文：https://stackoverflow.com/questions/17416856