php - CodeIgniter 数据库查询有错误但我没有看到

Question

if ($this->input->get('beds')) 
    $where['Bedrooms'] = $this->input->get('beds');

if ($this->input->get('baths'))
    $where['Bathrooms'] = $this->input->get('baths');

$min_price = ($this->input->get('min_price')) 
    ? $this->input->get('min_price')
    : '0';

$max_price = ($this->input->get('max_price'))
    ? $this->input->get('max_price')
    : '10000000';

$q = $this->db->select("*")
    ->where('ListingPrice <=', $max_price)
    ->where('ListingPrice >=', $min_price)
    ->limit(10)
    ->get();  

你呢？您可以相信所有的值(value)都在那里。

错误是:

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 'WHERE ListingPrice <= '100000' AND ListingPrice >= '0' LIMIT 10' at line 2

Answer 1

我不使用 CodeIgniter，但您的查询中似乎没有 FROM 元素