Welcome Guest, Not a member yet? Register   Sign In
$this->db->where bug?
#6

[eluser]darkroomdave[/eluser]
I ran the profiler on it to see what it was doing

SELECT * FROM (`categories`) WHERE `highlight=1` ORDER BY `orderid`

So it does break my existing code. Maybe it shouldn't back tick if there is a operator like = in there?

Obliviously it didn't before 1.7.1

I do usually use the array method but the same problem also broke this

$this->db->where(sprintf("parent_id=%s OR highlight=1", $id));

And yes I could of used or_where but I didn't


Messages In This Thread
$this->db->where bug? - by El Forum - 04-24-2009, 12:56 PM
$this->db->where bug? - by El Forum - 04-24-2009, 02:18 PM
$this->db->where bug? - by El Forum - 04-24-2009, 04:54 PM
$this->db->where bug? - by El Forum - 04-25-2009, 03:07 AM
$this->db->where bug? - by El Forum - 04-25-2009, 04:52 AM
$this->db->where bug? - by El Forum - 04-28-2009, 11:04 AM
$this->db->where bug? - by El Forum - 04-28-2009, 12:05 PM
$this->db->where bug? - by El Forum - 04-28-2009, 12:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB