doujiangqu2823 2014-06-05 20:39
浏览 35
已采纳

PHP为什么我的INNER JOIN返回错误?

I have this line of code:

$query = mysqli_query($connection, "SELECT `id`, `image`, `link`, `order` FROM `galleryImages` INNER JOIN `galleries` ON `galleryImages`.`galleryId` = `galleries`.`id`");

its returning this error:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result

full code:

$query = mysqli_query($connection, "SELECT `id`, `image`, `link`, `order` FROM `galleryImages` INNER JOIN `galleries` ON `galleryImages`.`galleryId` = `galleries`.`id`");
                $results = array();
                while($row = mysqli_fetch_assoc($query)){
                        $results[] = $row;
                }
                return $results;
  • 写回答

2条回答 默认 最新

  • doutou19761022 2014-06-05 21:04
    关注

    Try :

    "SELECT `id`, `image`, `link`, `order`
      FROM `galleryImages` `g`
      INNER JOIN `galleries` `g2` ON `g`.`galleryId` = `g2`.`id`"
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?