Unknown column xxx in 'where clause'

[eluser]R. Oerlemans[/eluser]
Hello There,

I am working on a bug(?) for a few hours now, but couln't fix it.

This is my code:

Code:

if(!$this->db->get_where('merken',array('m_name' => $brand))->count_all_results()){

$brand contains 'Acer' in this preview.

A Database Error Occurred

Error Number: 1054

Unknown column 'Acer' in 'where clause'

SELECT * FROM (`merken`) WHERE `m_name` = Acer

I want to check if it already exists, but it won't work very well.

[eluser]R. Oerlemans[/eluser]

Code:

$this->db->insert('merken',array('m_name' => $brand));

Also won't work with 'm_name' as a unique index in the table.

A Database Error Occurred

Error Number: 1054

Unknown column 'Acer' in 'field list'

INSERT INTO `merken` (`m_name`) VALUES (Acer)

[eluser]bgreene[/eluser]
what you need is SELECT * FROM (`merken`) WHERE `m_name` = "Acer"
and INSERT INTO `merken` (`m_name`) VALUES ("Acer")

[eluser]Armchair Samurai[/eluser]
[quote author="R. Oerlemans" date="1257019146"]I am working on a bug(?) for a few hours now, but couln't fix it.

This is my code:

Code:

if(!$this->db->get_where('merken',array('m_name' => $brand))->count_all_results()){

[/quote]
I don't think you can chain like that. In any case, try:

Code:

$this->db->where('m_name', $brand);

if ($this->db->count_all_results('merken') == 0)
{
    //continue code

[eluser]bretticus[/eluser]
get_where runs the query have you tried using only where() ?

if(!$this->db->where('m_name', $brand)->count_all_results('merken')){

}

Your insert example is indeed strange. What database driver re you using?