php - 没有“where”的查询仍然处理“where”

Question

运行此功能时：

function periksa_file(){    
    $this->db->select('f.id as id, k.id as kategori_id')->from('file as f')->join('kategori as k','f.id_kategori = k.id');
    return $this->db->get();
}

我收到此错误：

A Database Error Occurred
Error Number: 1052

Column 'id' in where clause is ambiguous

SELECT `f`.`id` as `id`, `k`.`id` as `kategori_id` FROM `file` as `f` JOIN `kategori` as `k` ON `f`.`id_kategori` = `k`.`id` WHERE `id` = ''

Filename: C:/File/xampp/htdocs/sistemfiledigital/system/database/DB_driver.php

Line Number: 691

为什么有一个“where”子句，即使我不叫它？

标签： phpmysqlcodeigniter-3

Answer 1

我刚刚发现“where”子句来自另一个遥远的电话，所以我需要把

$this->db->reset_query()

在调用选择之前。