dongzhijing8202 2016-01-11 17:05
浏览 59

使用PDO在两个数据库之间连接

I have two databases and I am trying to compare two tables. My code does not seem to be working, not sure what I am doing wrong.

Here is the code.

<?php
include 'connection.php';
/* 
 * This code compares between two tables
 */

//SQL call
$getData = $connection->prepare("SELECT `CustomerCity` FROM `auth` LEFT JOIN `tb_data.cobs.city` WHERE `CustomerCity` =  `tb_data.cobs.city` LIMIT 3");
$getData->execute();
$gotData = $getData->fetchAll(PDO::FETCH_ASSOC);
print_r($gotData);

In my database I have two tables, on is cobs, the other is tb_data. tb_data has a table called cobs and auth is a table within a database called d_data. Both of these tables have a city column. I need get every record in auth that has a city that matches in the cobs table.

  • 写回答

4条回答 默认 最新

  • doubei8541 2016-01-11 17:18
    关注

    The query is incorrect, you need to specify the link betweeen the tables auth and tb_data.cobs.city. For example:

    SELECT
        * 
    FROM 
        FOOTABLE FOO
    LEFT JOIN
        BARTABLE BAR ON BAR.FOO_ID FOO.ID = -- here goes the link between them
    WHERE
        ...
    
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图问题
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题