Query returns nothing.... [SOLVED]

[eluser]Frychiko[/eluser]
I have a query to get a row from a table,
to extract a row with a field = "Accessories - Mouse"

Code:

$this->db->select("*, merchant.name as merchant, ".$this->table.".id as id, category.name as category");
$this->db->join("merchant", "merchant.id = ".$this->table.".merchant_id");
$this->db->join("category", "category.id = ".$this->table.".category_id");
$this->db->where($new_where);

$query = $this->db->get($this->table);

Which converts to this, as tested in phpmyadmin:

Code:

SELECT * , merchant.name AS merchant, merchant_category.id AS id, category.name AS category
FROM (
`merchant_category`
)
JOIN `merchant` ON merchant.id = merchant_category.merchant_id
JOIN `category` ON category.id = merchant_category.category_id
WHERE merchant_category.display = 'Accessories - Mouse'

CI returns nothing:

Code:

echo "search results:".$query->num_rows();

but, phpmyadmin returns a row, which should be the correct result:

Showing rows 0 - 0 (1 total, Query took 0.0008 sec)


45, Accessories Mouse, Accessories - Mouse, 4, 17, 96, 4, newegg, NewEgg....

What is going on here? It's driving me insane